Skip to content

Registered aircraft · 8,139

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:96-10-01-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:96-10-01-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:96-10-01-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:96-10-01-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:96-10-01-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:96-10-01-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.

N5776UBrainard Gary Keith · Olney, ILBuilt 1969 · S/N 28-26600 N5777UFossa Matthew A · Pensacola, FLBuilt 1969 · S/N 28-26601 N5777WMaschek Anothony Q · Killeen, TXBuilt 1964 · S/N 28-1585 N5779FScheer Abraham · Milton, DEBuilt 1968 · S/N 28-25085 N577FLMorsi Sameh M · Pomona, CABuilt 1971 · S/N 28-7125428 N5780FAces Aviation LLC · Laurel, MTS/N 28-25087 N5780WSmoyer Justin L · Slatington, PABuilt 1964 · S/N 28-1657 N5781FRegistered aircraftBuilt 1968 · S/N 28-25088 N5781WPietras Aaron E · Franklin, INBuilt 1964 · S/N 28-1658 N5782FMission Aviators LLC · Spring, TXBuilt 1968 · S/N 28-25089 N5782WDavis Clinton · Baldwin City, KSBuilt 1964 · S/N 28-1659 N5783FBate Eric D · Vancouver BcBuilt 1976 · S/N 28-7725066 N5783ULindberg Kyle J · Pahrump, NVBuilt 1970 · S/N 28-26607 N5783WDillard Joseph · Thaxton, MSBuilt 1964 · S/N 28-1660 N5784FCrocker James Fuller · Trussville, ALBuilt 1968 · S/N 28-25090 N5784UMchenry Charles · Siloam Springs, ARBuilt 1970 · S/N 28-26608 N5785UZanino James A · Sterling, MABuilt 1970 · S/N 28-26609 N5785WLilu LLC · Siloam Springs, ARBuilt 1964 · S/N 28-1671 N5786FPalazzi Michael A · Longmeadow, MABuilt 1968 · S/N 28-25094 N5786UCampbell Ashley H · Colorado Springs, COBuilt 1969 · S/N 28-26611 N5786WPowers Meranda M · Nampa, IDBuilt 1964 · S/N 28-1676 N5787UCodreanu Octavian · Thorndale, PAFirst renewal noticeBuilt 1969 · S/N 28-26612 N5787WNewsome Robert K · Linwood, NCBuilt 1964 · S/N 28-1680 N5788WTech Flight Corp · South Hamilton, MABuilt 1964 · S/N 28-1688 N5789FKarnegis Frank J · Senoia, GABuilt 1968 · S/N 28-25096 N5789WLewandowski Robert G · Crestwood, KYBuilt 1964 · S/N 28-1693 N578FLChapin William C · Jackson, MIBuilt 1971 · S/N 28-7125430 N5790FRenner Thomas F · Chandler, AZBuilt 1968 · S/N 28-25097 N5791FTihomirovs Dennis · Piseco, NYBuilt 1968 · S/N 28-25099 N5791WMotta Ron DBA · West Palm Beach, FLBuilt 1964 · S/N 28-1707 N5792WSchulman Henry N · Mc Ewen, TNBuilt 1964 · S/N 28-1717 N5793UDfw Skydreams LLC · Fort Worth, TXBuilt 1970 · S/N 28-26619 N5794UBuckley Joseph · Mora, MNBuilt 1969 · S/N 28-26620 N5795UAg Air Squardron One LLC · Saint Joseph, ILBuilt 1969 · S/N 28-26621 N5795WMyer Lucas O · Huntsville, ARBuilt 1964 · S/N 28-1749 N5799FDunten Teri · Moses Lake, WAS/N 28-25107 N5799URowe James H · Warrington, PAS/N 28-26626 N579PRSolla Miguel A · Dorado, PRBuilt 1971 · S/N 28-7105083 N57GMYonke Gregory S · Fort Wayne, INBuilt 1971 · S/N 28-7125516 N57WDDarling William H · Sprakers, NYBuilt 1966 · S/N 28-3395 N5803WClifford William M · North East, MDBuilt 1964 · S/N 28-1877 N5804USand Piper Air LLC · Endicott, NYBuilt 1970 · S/N 28-26632 N5804WBard Nathan R · Carlisle, PABuilt 1964 · S/N 28-1895 N5805UFoxtrot Three Flying Services LLC · Henderson, NVBuilt 1970 · S/N 28-26633 N5805WPackett Robert E · Silverdale, WAFirst renewal noticeBuilt 1964 · S/N 28-1897 N5808WYoung Victor G · Federal Way, WABuilt 1964 · S/N 28-1922 N5809WRegistered aircraftBuilt 1964 · S/N 28-1926 N580FLWaves4days LLC · El Segundo, CABuilt 1971 · S/N 28-7125433 N5810USmith Herbert E · Rochelle, ILBuilt 1969 · S/N 28-26638 N5812USeymour Lori L · Woodstock, GABuilt 1969 · S/N 28-26641

Back to AD 96-10-01 R1