Registered aircraft · 108,433

Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.

Query with SQL

SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:2007-04-19-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2007-04-19-R1') ORDER BY n_number

duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:2007-04-19-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2007-04-19-R1')
  ORDER BY n_number"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:2007-04-19-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2007-04-19-R1')
ORDER BY n_number

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N2135ZCapps Boyce Daniel · Newcastle, OKBuilt 1963 · S/N 18051235 N21360Weede Roger H · Dubois, WYS/N 17263935 N21362Joyce James R · Bellevue, WABuilt 1972 · S/N 18261587 N21368Alta Air LLC · Boise, IDBuilt 1972 · S/N 18261589 N21369Smk Holdings LLC · Sandy, UTBuilt 2003 · S/N 18281292 N2136CPope Keith D · Mineral Wells, TXBuilt 1978 · S/N 28-7911022 N2136GCulver Deborah M · Anchorage, AKBuilt 1958 · S/N 51436 N2136JHanus John E · North Kingstown, RIBuilt 1978 · S/N 28-7990219 N2136MWashington Israel · Cincinnati, OHBuilt 1977 · S/N 28-7816253 N2136RGibbens John L Trustee · Rock Springs, WYBuilt 1964 · S/N 18255336 N2136WMills Robert D · Newport, MIBuilt 1974 · S/N E-568 N2136YW Tech Consulting Inc · Wilmington, DEBuilt 1979 · S/N 28-7916368 N2136ZPorta Frank T · Charleston, WVBuilt 1979 · S/N 28R-7918111 N21370Garner Jan L · Fremont, OHBuilt 1972 · S/N 18261591 N21374Stratus Aviation LLC DBA · Vacaville, CABuilt 1974 · S/N 17263938 N21376Vodry John · Quilcene, WABuilt 1972 · S/N 18261596 N2137FColakoglu Migirdic · Hilton, NYBuilt 1978 · S/N 28-7911048 N2137JAdverse Yaw LLC · Milford, CTBuilt 1978 · S/N 28-7916205 N2137RFreefall Express Inc · Gardiner, NYBuilt 1964 · S/N 18255337 N2137TWatson Jay C · Midland, TXBuilt 1971 · S/N 28-7105160 N2137ZAnderson Kenneth L · Anchorage, AKBuilt 1963 · S/N 18051237 N21389Registration Pending · Waldo, WIRegistration pendingBuilt 1974 · S/N 17263942 N2138CAv Holding Co LLC · Polson, MTBuilt 1986 · S/N 46-8608020 N2138NJ T Air Inc · Dayton, MDBuilt 1979 · S/N 28-7911094 N2138PRedwood Barry Lindon · Forest, VABuilt 1956 · S/N 23-729 N2138RWisdom Victor · Sterling, COBuilt 1965 · S/N 646 N2138SStamm Roy Peter · Woodstock, GABuilt 1975 · S/N 21061099 N2138WChristiansen Aviation LLC · Wilmington, DEBuilt 2003 · S/N 172S9561 N2138ZPyle Richard B · El Paso, TXBuilt 1998 · S/N 29-0158 N21393Dinelli Aviation LLC · Milton, DES/N 18261607 N21394Long Island Aviators LLC · Seaford, NYBuilt 2007 · S/N 172S10449 N21395Faignant J Brian Jr · Anchorage, AKBuilt 1972 · S/N 18261608 N21396Greers Banner Air Of Bakersfield Inc · Bakersfield, CABuilt 1972 · S/N 18261609 N21398Peterson Peter M · Silverado, CABuilt 1977 · S/N D-10077 N2139BN2139b LLC · Newark, DEBuilt 1978 · S/N 28-7911009 N2139FCrow Brian M · Oakesdale, WABuilt 1965 · S/N U206-0339 N2139GSoarmates LLC · Missoula, MTBuilt 1958 · S/N 51439 N2139JHotung Lisa M · Amherst, NYBuilt 1978 · S/N 28-7990220 N2139RShaw Gregory A · West Richland, WABuilt 1964 · S/N 18255339 N2139TFlight School Of Gwinnett Inc · Lawrenceville, GABuilt 1971 · S/N 28R-7135145 N2139UJust Plane Stuff Inc · Jackson, MSBuilt 2007 · S/N 172S10448 N2139WRegistration Pending · Lake Worth, FLRegistration pendingBuilt 1974 · S/N M-1509 N213AMNorton Cole R · Marion, IAS/N 559-73 N213AWTelford Aircraft LLC · Telford, TNBuilt 2006 · S/N 11344 N213AZHardcastle Kenny W · Caulfield, MOBuilt 2018 · S/N 90277 N213BGUpstate Flyers LLC · Woodruff, SCBuilt 1972 · S/N 18261580 N213BPJim Nichols Air Service LLC · Fincastle, VABuilt 1986 · S/N 28-8690056 N213CBSkymates Inc · Wilmington, DEBuilt 2002 · S/N 4496147 N213CDJungman Frank · Escondido, CABuilt 2000 · S/N 1111 N213CMBollingberg Kurt O · Cathay, NDBuilt 1997 · S/N 18280046

Back to AD 2007-04-19 R1