Registered aircraft · 108,428

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.

N161WAWashburn Aviation LLC · Murfreesboro, TNS/N 5259 N162Payne David J · Eagle River, AKBuilt 1957 · S/N 22-5677 N1620ABeaver David W Trustee · Wasilla, AKBuilt 1952 · S/N 18-1263 N1620GDrexler Charles T · Albuquerque, NMBuilt 1968 · S/N 123 N1620PNielsen Mona · Ford, WABuilt 1954 · S/N 22-2434 N1621Diem Ronald · Myerstown, PABuilt 2025 · S/N 18283315 N1621WColeman Alan · Tyler, TXBuilt 1972 · S/N TC-1455 N1622AKelly Steven L · Saline, MIBuilt 2016 · S/N 5574 N1622CPutnal Aviation LLC · Ambrose, GABuilt 1953 · S/N 30322 N1622PBaker Kenneth C · Brenham, TXBuilt 1992 · S/N 3213040 N1622TMcpherson Bruce A · Burien, WABuilt 1962 · S/N NAV-4-2468 N1622WN83993 LLC · Cherry Hill, NJExpired dealer, pending cancellationBuilt 1972 · S/N TE-870 N16237Main Line Assets LLC · Wayne, PABuilt 2005 · S/N 172S9912 N1623MMountain Ranch Air Inc · Sioux Falls, SDS/N 18264396 N1624Going Somewhere LLC · Dover, DEBuilt 2018 · S/N 18283056 N16244Oakland William S · New Port Richey, FLBuilt 1973 · S/N 28-7305211 N1624HSynergy Aviation LLC · Forest Lake, MNBuilt 1977 · S/N 18503317 N1624TMelnik Charles J DBA · Omaha, NES/N 414-0404 N1624WHill Travis · Smithville, TXBuilt 1972 · S/N CE-384 N162505b Aviation LLC · Duncan, OKBuilt 1973 · S/N 28-7305212 N16252Robbins Warren N · Chandler, AZBuilt 1973 · S/N 28-7305213 N16257Chauvet Nicolas · North Kingstown, RIBuilt 1973 · S/N 28-7305216 N1625CK&C Technologies LLC · Belleville, WIBuilt 2003 · S/N 0584 N1625GPippert Jim · Dysart, IABuilt 1968 · S/N 127 N1625JCain Philip K · Escondido, CABuilt 1968 · S/N 28-24818 N1625LArtime Jorge Daniel · Miami Beach, FLBuilt 1979 · S/N 13 N1625PGauthier Robert Jones · Melba, IDBuilt 1954 · S/N 22-2439 N1625UFly2k LLC · San Jose, CABuilt 1982 · S/N 21064710 N1625WGunter Professional Pilot Services LLC · Wichita Falls, TXBuilt 1972 · S/N D-9365 N1626CLabrecque Maurice O · Anchorage, AKBuilt 1953 · S/N 30326 N1626JLawrence Gavin · Borger, TXBuilt 1967 · S/N 28-24013 N1626WSallman Ramsey N · Niceville, FLBuilt 1972 · S/N CD-1294 N16273Taildraggers LLC · Syracuse, KSBuilt 1973 · S/N 28-7305217 N16278Cademartori Joel T · Norris, TNBuilt 1973 · S/N 28R-7335121 N16279Deyoung Christopher H · Tucson, AZBuilt 1973 · S/N 28-7310083 N1627APlettner David C · Sutton, NEBuilt 1951 · S/N 18-1267 N1627CTerry Michael R Trustee · Bullhead City, AZBuilt 1953 · S/N 30327 N1627EWichterman George J Trustee · Fort Myers, FLBuilt 1978 · S/N 17271070 N1627HCirrus Services Inc · Fargo, NDBuilt 1977 · S/N 28-7716028 N1627PMiller Wesley M · Crookston, MNBuilt 1954 · S/N 22-2441 N1627TSierra Leasing LLC · Sheffield, ALBuilt 1973 · S/N 414-0407 N16283Winn Philip P · Salem, OHBuilt 1973 · S/N 28-7325231 N16284Rocco Jeffrey M · Carson, CABuilt 1969 · S/N 28-26015 N16288Bailey Brent M · Dalzell, SCBuilt 1973 · S/N 28-7325234 N16289Williams Kevin L · Buchanan, TNBuilt 1973 · S/N 28-7325235 N1628HWarrior N1628h LLC · Huntsville, ALBuilt 1977 · S/N 28-7716029 N1628ZVertex Aviation LLC · Kodiak, AKBuilt 1962 · S/N 185-0428 N16292Morcom Aviation Services Inc DBA · Everett, WABuilt 1973 · S/N 34-7350125 N16293Quale Jeffrey L · Craig, COFirst renewal noticeBuilt 1973 · S/N 28R-7335123 N16299Piper Niner Niner LLC · Evansville, INBuilt 1973 · S/N 28-7310084

Back to AD 2007-04-19 R1