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.

N761LQFlying Pharaohs LLC · Fredericksburg, VABuilt 1977 · S/N 21062344 N761LUStowell Robert W · La Porte, INBuilt 1977 · S/N 21062348 N761LYHigh Flying Texans LLC · Arlington, TXS/N 21062352 N761MAWilliams Charlie · Trenton, SCS/N 15065219 N761MBGump Timothy K · Dalton Gardens, IDBuilt 1977 · S/N 21062354 N761MERoseburg Skyways LLC · Livermore, CAS/N 21062357 N761MJFritz Mark Andrew · Williamson, GABuilt 1977 · S/N 21062361 N761MSHarvey Scott · Hereford, AZBuilt 1977 · S/N 21062369 N761NTStroud Mark W · Durango, COBuilt 1977 · S/N 21062393 N761PJGateway Flying Club Inc · Blaine, MNBuilt 1976 · S/N 18264787 N761PPSoheily Holdings LLC · Austin, TXBuilt 1977 · S/N 21062412 N761PRBluff City Bell LLC · Caldwell, IDBuilt 1977 · S/N 21062414 N761PVKomen Mark R · Seattle, WABuilt 1977 · S/N 21062418 N761QAErnst Gary W · Emerald Hills, CABuilt 1977 · S/N 21062423 N761QVNavratil Philip R · Houston, TXBuilt 1977 · S/N 21062442 N761QXAerial Art Photography · Altadena, CABuilt 1978 · S/N 21062444 N761QYYardbird Corp · Nevada, IABuilt 1977 · S/N 21062445 N761RCClannalu Air LLC · Midland, TXBuilt 1978 · S/N 21062449 N761RDRobinson John · Farmington, NMBuilt 1978 · S/N 21062450 N761RESecrest Steven J · Roosevelt, UTBuilt 1978 · S/N 21062451 N761RGBas Part Sales LLC · Greeley, COS/N 21062453 N761RLCampbell Gordon S · Concord, CABuilt 1978 · S/N 21062457 N761SBBracl Holdings LLC · Tonganoxie, KSBuilt 1978 · S/N 21062471 N761SFParamount Enterprises Inc · Goldsboro, NCBuilt 1978 · S/N 21062475 N761SGThurmond Clark · Georgetown, TXBuilt 1978 · S/N 21062476 N761SHJs Flying Services LLC · Reno, NVBuilt 1978 · S/N 21062477 N761SPTwin City Cloud 7 Inc · Eden Prairie, MNBuilt 1978 · S/N 21062483 N761STBode Aviation Inc · Albuquerque, NMBuilt 1978 · S/N 21062487 N761SVVogt Richard L · Panama City, FLBuilt 1978 · S/N 21062489 N761TCMichigan Scientific Corp · Milford, MIBuilt 1978 · S/N 21062496 N761TEDraegerweb Aviation LLC · Linden, MIBuilt 1978 · S/N 21062498 N761THBlack Forest Wings LLC · Noblesville, INBuilt 1978 · S/N 21062501 N761TKRichards And Richards · Nucla, COBuilt 1978 · S/N 21062503 N761TLOmni International Services Inc · Reno, NVBuilt 1978 · S/N 21062504 N761TMHwbec761 LLC · Los Ranchos, NMBuilt 1978 · S/N 21062505 N761TYAdw N761ty LLC · Chicago, ILBuilt 1978 · S/N 21062516 N761UAFirst Wings LLC · Sayre, PAS/N A1520986 N761UELevitt Stephen John · Lafayette, INBuilt 1978 · S/N 21062522 N761UPChilhowee Trailer Sales Inc · Alcoa, TNBuilt 1978 · S/N 21062531 N761VTCharlie Kilo Romeo LLC · Georgetown, TXBuilt 1978 · S/N 21062559 N761VWKennedy M John · Gillette, WYBuilt 1978 · S/N 21062562 N761WHPierson Tim E · Gooding, IDBuilt 1978 · S/N 21062573 N761WQTower Aircraft Associates Inc · Ventura, CAS/N 21062580 N761WTCv Aviation LLC · Logan, UTBuilt 1978 · S/N 21062583 N761XDSdf Air LLC · Wilmington, DEBuilt 1978 · S/N 21062593 N761XEGordon Bruce S Trustee · Aspen, COBuilt 1978 · S/N 21062594 N761XFRapa Dennis H · North Dartmouth, MAS/N 21062595 N761XGMedusa Inc · Lexington, VABuilt 1978 · S/N 21062596 N761XSTechnology Holdings Inc · Columbus, INS/N 21062606 N761XYAshby Scott J · Lemoore, CABuilt 1978 · S/N 21062612

Back to AD 87-20-03 R2