Skip to content

Registered aircraft · 81,733

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:81-18-04-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:81-18-04-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:81-18-04-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:81-18-04-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:81-18-04-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:81-18-04-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.

N388PGAviator Air Flight School LLC · Grand Prairie, TXBuilt 1972 · S/N 17260525 N388XWarner Walt M · Willow, AKBuilt 1976 · S/N 7018C N388ZThornburg Steven D · Northville, MIBuilt 1997 · S/N 095 N38900Thompson Henry S · Plantsville, CTBuilt 1977 · S/N 28-7790604 N38901Weintraub Beverly · New York, NYBuilt 1977 · S/N 28-7790606 N38905Heins Andrew S · Dayton, OHBuilt 1941 · S/N AF-828 N38908Mollere Michael E · Marion, TXBuilt 1977 · S/N 32R-7780487 N3890KClark David L · Arlington, TXBuilt 1946 · S/N 1283 N3890MMiller Daniel O · Sugarcreek, OHBuilt 1947 · S/N 12-2580 N3890WRobinson Mark A · Carson City, NVBuilt 1967 · S/N 32-914 N3890ZIngman Joshua P · Dickinson, NDBuilt 1961 · S/N 18-7706 N38910Sitta Donald C · Farmington, NMBuilt 1940 · S/N AP833 N38911Sams Aviation LLC · Decatur, ILBuilt 1977 · S/N 32R-7780488 N38912Congco Antoine Mark J · New Caney, TXBuilt 1977 · S/N 32R-7780489 N38914Acadian Aviation Pilot Training Centre Inc · Lafayette, LABuilt 1977 · S/N 28-7716291 N38917Flying Low Racing LLC · Oklahoma City, OKBuilt 1941 · S/N A-840 N38919Sale Reported · Sarasota, FLSale reportedBuilt 1977 · S/N 28R-7737123 N3891MHall David B · Newburg, NDBuilt 1947 · S/N 12-2793 N3891QRiley George L III · Washington, INBuilt 1971 · S/N 17259991 N3891TJones Rodney D · Corcoran, CABuilt 1967 · S/N 28R-30220 N3891ZLaudon Sydney L · Anchorage, AKS/N 18-7707 N38922Iler Elden · Van Nuys, CABuilt 1941 · S/N A-845 N3892KRowley Rodney N · Duchesne, UTS/N 28-23763 N3892NNeed For Speed Inc · Dover, DEBuilt 1968 · S/N 680145 N3892QKcn Aero Club Inc · Overland Park, KSS/N 17259992 N3892ZWinston Christopher C · Vancouver, WABuilt 1961 · S/N 18-7708 N3893QSisung Ty J · Roxie, MSBuilt 1971 · S/N 17259993 N38945Southern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1977 · S/N 32R-7780490 N3894FNorth Shore Aero Club · Beverly, MABuilt 1976 · S/N 28-7690459 N3894MMiller Mark R · Hagerman, IDBuilt 1947 · S/N 12-2794 N3894TBsa Leasing LLC · Pocatello, IDBuilt 1967 · S/N 28R-30223 N3894WElite Fleet Jacksonville LLC · Jacksonville, FLBuilt 1966 · S/N 32-840 N38952Ponto Phillip R · Vista, CABuilt 1977 · S/N 28-7716297 N38954Faulkner Wade DBA · Sterrett, ALBuilt 1977 · S/N 28-7716299 N3895FGreever Steven M · Spearman, TXBuilt 1977 · S/N 28R-7737002 N3895TPaetzold Carson · Jacksonville, FLBuilt 1967 · S/N 28R-30224 N38968Vagabond Flying Association · Winfield, ILBuilt 1977 · S/N 28-7716300 N38969Vandervelden Harmen J · Ware, MABuilt 1977 · S/N 28-7716301 N3896FEssary Larry R · Mc Neal, AZS/N 28R-7635376 N3896MBehm Jerome William · Burlington, NDBuilt 1947 · S/N 12-2796 N3896QNishna Valley Flying Club · Red Oak, IABuilt 1971 · S/N 17259996 N3896ZDriggs Daniel H · Anchorage, AKBuilt 1961 · S/N 18-7674 N38970Triple R Aviation LLC · Cleburne, TXBuilt 1977 · S/N 28-7716302 N38972August Aero LLC · Kalispell, MTS/N 28-7716304 N38974International Air Services Inc Trustee · Carson City, NVBuilt 1976 · S/N 28-7716305 N3897XRegistration Pending · Greenwood, INRegistration pendingBuilt 1967 · S/N 134 N3897ZWard Joseph Delon · Wasilla, AKS/N 18-7788 N38984Registered aircraftS/N 32R-7780495 N38986Ascend Aviation LLC · Bountiful, UTBuilt 1977 · S/N 28-7716306 N38987Ocean City Flying Club LLC · Middletown, RIBuilt 1977 · S/N 28-7716308

Back to AD 81-18-04 R2