Skip to content

Registered aircraft · 54,020

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:87-20-03-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-20-03-R2') 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:87-20-03-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-20-03-R2')
  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:87-20-03-R2')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-20-03-R2')
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.

N1372VBoland Matthew S · Anchorage, AKS/N U20602588 N13731East Derrick A · Cullman, ALBuilt 1974 · S/N 17262977 N13732Bay Lux Ventures LLC · Tampa, FLBuilt 1974 · S/N 17262978 N13733Kelleher James · Nevada City, CABuilt 1976 · S/N 17702462 N13734Red Bird Flyers LLC · Acton, MABuilt 1976 · S/N 17702463 N13737Crosswinds Flight Center Inc · Drums, PABuilt 1974 · S/N 17262983 N13739Maroldy Robert S · Gahanna, OHBuilt 1974 · S/N 17262985 N1373CDoft Peter · San Diego, CAS/N 17702714 N1373EEagle Aviation LLC · Spearfish, SDBuilt 1978 · S/N 17270975 N1373FBaczewski Gary L · San Antonio, TXBuilt 1975 · S/N 18502837 N1373UWestberg Larry A · Milton, WIBuilt 1976 · S/N 17267044 N13740Gigax Steven G · Archbold, OHBuilt 1976 · S/N 17702465 N13741Rasmussen Tyler R · Independence, IAS/N 17262987 N13747Namund LLC · Roscommon, MIBuilt 1976 · S/N 17702466 N13748Ries Farms LLC · Hastings, MNS/N 17262989 N13749Son Of Jubal Ministry LLC · Bainbridge, GAS/N 17702467 N1374EKjeldgaard James K · Fremont, NEBuilt 1978 · S/N 17270976 N1374FHegge Luke T · Pine City, MNBuilt 1966 · S/N 17254869 N1374QAdams Robert J · Syracuse, NYS/N 15072674 N1374SRenninger Log Homes · Meeker, COS/N 18264936 N1374USkydance Aviation LLC · Norfolk, VABuilt 1976 · S/N 17267045 N1374YBowden Richard P · Lenexa, KSBuilt 1961 · S/N 17249074 N13751Stegmaier Ann C · Eagan, MNBuilt 1974 · S/N 17262992 N13752Coffman Aviation Inc · Jacksonville, FLBuilt 1974 · S/N 17262993 N13753Reeves Christopher A · Statesville, NCBuilt 1974 · S/N 17262994 N13754Durrum Frank D III · Mount Pleasant, TXBuilt 1974 · S/N 17262995 N13756Sky West Aviation Inc Trustee · Albuquerque, NMBuilt 1976 · S/N 17702468 N13757Nelson Robert Brett · Point Roberts, WABuilt 1976 · S/N 17702469 N1375CConn James Michael · Alexandria, MNBuilt 1977 · S/N 17702715 N1375LAviation Specialty Services LLC · Beaufort, NCBuilt 1978 · S/N 33701867 N1376FWerderich George A · Bartlett, ILBuilt 1966 · S/N 17254871 N1376MBauman Cecil Davis · Nashville, TNBuilt 1975 · S/N 18264303 N1376QPaciej Bernard P · Luzerne, PABuilt 1971 · S/N 15072676 N1376SClarklind Farms · Tulare, CAS/N 18264938 N13770Countryside Academy · Benton Harbor, MIBuilt 1974 · S/N 17263001 N13778Weitekamp Shawn Paul · Roanoke Rapids, NCBuilt 1974 · S/N 17263003 N1377CCavok LLC · Wilmington, DES/N 17702716 N1377DJohnson Lawrence F · Anchorage, AKBuilt 1951 · S/N 19953 N1377EFly Barely LLC · Manitowoc, WIBuilt 1978 · S/N 17270978 N1377FMartinelli James · Madras, ORBuilt 1966 · S/N 17254872 N1377MBuiqui Aerospace Corp · Kissimmee, FLBuilt 1972 · S/N 17260577 N1377UWifa (Washington International Flight Academy) LLC · Wilmington, DEBuilt 1976 · S/N 17267048 N13786Diapaola Anthony Sr · New Eagle, PABuilt 1974 · S/N 17263004 N1378DPalmerlee John B · Santa Rosa, CABuilt 1951 · S/N 19954 N1378MCavok LLC · La Vergne, TNBuilt 1972 · S/N 17260578 N1378QOppegard Nicholas · Eagle River, AKBuilt 1971 · S/N 15072678 N1378SEngle William A · Bend, ORBuilt 1976 · S/N 18264940 N13796Positive Attitude Ia LLC · Gaithersburg, MDBuilt 1974 · S/N 17263006 N1379DGods Chosen Flyers LLC · Apex, NCBuilt 1951 · S/N 19955 N1379SMorris William Alan · Newnan, GABuilt 1976 · S/N 18264941

Back to AD 87-20-03 R2