Skip to content

Registered aircraft · 54,015

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.

N738LNSidor David R · Palm Desert, CABuilt 1977 · S/N 17270063 N738LPPython Financial LLC · Kalispell, MTBuilt 1979 · S/N R18200938 N738LSKingfisher Assurance LLC · Fort Worth, TXBuilt 1979 · S/N R18200939 N738LUUrquhart Air LLC · Parker, COS/N R18200940 N738LVUrban Aviation Services Inc · Paxton, MABuilt 1977 · S/N 17270070 N738MCMoore Michael E · Shawnee, KSS/N 17270076 N738MEN738me LLC · Miami, FLS/N 17270078 N738MHCurtis Creek Aviation LLC · Kalispell, MTS/N 17270081 N738MJOptic Air LLC · Sioux Center, IABuilt 1977 · S/N 17270082 N738MKObrien Aviation Inc · Port Orange, FLBuilt 1977 · S/N 17270083 N738MLSouthern Wings Aircraft Sales Ltd · Bethany, OKBuilt 1977 · S/N 17270084 N738MRNew World Air LLC · Orland Park, ILS/N 17270088 N738MTJulep Arbor Flying LLC · Salisbury, NCBuilt 1977 · S/N 17270090 N738MWN738mw LLC · Jupiter, FLBuilt 1977 · S/N 17270093 N738MZCarrasco Alonzo · Burleson, TXBuilt 1977 · S/N 17270096 N738NBLele Aviation LLC · Denver, COBuilt 1977 · S/N 17270098 N738NCAndrosky Mark J · Superior, WIBuilt 1977 · S/N 17270099 N738NDFood From The Forest LLC · Wilmington, DEBuilt 1977 · S/N 17270100 N738NGMusson Jeffrey L · Racine, WIBuilt 1977 · S/N 17270103 N738NHUS Navy Commander Navy Installation Command · Millington, TNBuilt 1978 · S/N 17270104 N738NKAscutney Air LLC · Claremont, NHBuilt 1977 · S/N 17270106 N738NMRegistration Pending · Burlington, WIRegistration pendingS/N 17270108 N738NNAero Aviation LLC · Long Beach, CABuilt 1977 · S/N 17270109 N738NQSimmons Calvin L · Washington, UTBuilt 1979 · S/N R18200945 N738NSGibson Field · Paso Robles, CABuilt 1979 · S/N R18200947 N738NTChamberlain Sheldon L · Patterson, LABuilt 1977 · S/N 17270114 N738NUAeroflyin Corp · Miramar, FLS/N 17270115 N738NXAbove All Aviation Inc · Goleta, CABuilt 1977 · S/N 17270118 N738NYMonmouth Area Flying Club Inc · Lakewood, NJBuilt 1977 · S/N 17270119 N738PDMontgomery Robert E · Fairfax, VABuilt 1977 · S/N 17270123 N738PGBas Part Sales LLC · Greeley, COBuilt 1979 · S/N R18200949 N738PHStroemsvik Kristian · Strasburg, VABuilt 1977 · S/N 17270127 N738PJGeebee Ventures LLC · Belgrade, MTBuilt 1977 · S/N 17270128 N738PKTss Flying Club Inc · Bethesda, MDBuilt 1979 · S/N R18200950 N738PMDaviation Inc · Willoughby, OHBuilt 1977 · S/N 17270131 N738PNPapa November LLC · Orlando, FLBuilt 1977 · S/N 17270132 N738PP8 Papa Papa Flyers LLC · Little Rock, ARBuilt 1977 · S/N 17270133 N738PRS D Sky Tales Inc · Chuckey, TNBuilt 1979 · S/N R18200951 N738PTMitchell Clayton M · Monte Vista, COBuilt 1977 · S/N 17270137 N738PVLawn Dart Flyers LLC · Shelburne, VTBuilt 1977 · S/N 17270139 N738PWLamey Kevin P Trustee · Missoula, MTS/N R18200952 N738PXMacomb County Sheriffs Aviation Division · Oakland, MIBuilt 1977 · S/N 17270141 N738QASorbi Aviation Inc · El Cajon, CAFirst renewal noticeBuilt 1977 · S/N 17270144 N738QBRed Baron LLC · Middletown, DEBuilt 1977 · S/N 17270145 N738QCMagda Michael J · Whitmore Lake, MIBuilt 1977 · S/N 17270146 N738QEAero Aviation Transportion Inc · Wilmington, DEBuilt 1977 · S/N 17270148 N738QFClark Josh D · Morehead, KYS/N 17270149 N738QJCarr Lonnie G · Sparta, TNBuilt 1977 · S/N 17270152 N738QKSik Kelly · Murrieta, CABuilt 1979 · S/N R18200953 N738QMWalters James F · Richton, MSBuilt 1977 · S/N 17270155

Back to AD 87-20-03 R2