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.

N46420Frontier Environmental Solutions Inc · Inyokern, CAS/N 17257256 N46423Parrish Aviation Flight Academy LLC · Southlake, TXS/N 17257259 N4642PColumbus Sign Co · Columbus, GAS/N 27-163 N4642RSkyways Group LLC · Greensboro, NCBuilt 1966 · S/N 28-21396 N4642VBolster William L · Joshua Tree, CABuilt 1978 · S/N VAC-96-78 N4642WHash Marshall W · Crumpler, NCS/N 13172 N4642YFriends Aviation Inc · Wilmington, DEBuilt 1967 · S/N 25-4361 N46430J & Dk LLC · Overland Park, KSBuilt 1968 · S/N 17257263 N46433Plummer Fred C · Normal, ILBuilt 1968 · S/N 17257264 N46435Hawkins County Sports Wings Inc · Kingsport, TNBuilt 1968 · S/N 17257266 N46436Aero Science International LLC · Martinez, GABuilt 1968 · S/N 17257267 N46437Arizona Active Air LLC · Yuma, AZBuilt 1968 · S/N 17257268 N46440Engelskirger Karl D · Valley City, OHS/N 17257270 N46442Lott Terence D · Florence, MSBuilt 1968 · S/N 17257272 N46448Mac Air Inc · Farmington, MOBuilt 1968 · S/N 17257276 N46449Tilma Flying Club Inc · Moscow, IDBuilt 1968 · S/N 17257277 N4644JWinslow Francis E III · Raleigh, NCS/N 17273659 N4644PFennema Alan A · San Jose, CABuilt 1960 · S/N 27-165 N4644VHendricks Trenton Q · Bow, WABuilt 1978 · S/N VAC-98-78 N4644YState Of Montana · Helena, MTBuilt 1971 · S/N 18-8945 N4645Ladage Terry L · Champaign, ILBuilt 1979 · S/N 189 N46457Ostrowski Sven E · Mullica Hill, NJS/N 17257281 N4645JHitchcock Scott B · Waco, TXBuilt 1968 · S/N 28R-30538 N4645RKunz Consulting Inc · Sun Prairie, WIBuilt 1966 · S/N 28-21399 N4645WClimb Maintain LLC · Morrisville, MOBuilt 1977 · S/N 13175 N4646Bailey Christopher J · Riga, MIBuilt 1975 · S/N M-II-480 N46460Walter Timothy G · Farmersburg, IABuilt 1968 · S/N 17257283 N46462Cook Aviation Services LLC · Fargo, NDBuilt 1968 · S/N 17257285 N4646JCulley Johnny C · Amarillo, TXBuilt 1968 · S/N 28R-30539 N4646RWarren Global LLC · Chino, CABuilt 1966 · S/N 28-21400 N4646VBaran Stephen · Littlestown, PABuilt 1978 · S/N VAC-100-78 N46470Registration Pending · St Charles, ILRegistration pendingBuilt 1968 · S/N 17257291 N46473Aviation Capital Management LLC · San Jose, CABuilt 1978 · S/N 15283056 N4647QCowles Charles Orville · Mesa, AZS/N 71576 N46484Campisteguy Alexander J · Renton, WABuilt 1968 · S/N 17257298 N46486Calimesa LLC · North Las Vegas, NVBuilt 1968 · S/N 17257300 N46487Silver Express Co · Miami, FLBuilt 1978 · S/N 15283061 N4648JTutt Bryan · Louisville, KYS/N 28R-30542 N4648MKaye Mykle · Wailuku, HIBuilt 1949 · S/N 14-495 N46493Brown Michael F · Richford, NYBuilt 1974 · S/N 17264186 N46495Hanna Douglas L · Winchester, KYBuilt 1968 · S/N 17257306 N46497Tones Trucking Inc · Cassopolis, MIBuilt 1968 · S/N 17257307 N4649MDaviation Inc · Willoughby, OHBuilt 1980 · S/N 15284474 N4649QSkyhawk Services LLC · Lake Wales, FLBuilt 1973 · S/N 17261735 N4649RHartley Zachary K · Dublin, GABuilt 1966 · S/N 28-21404 N4649SBrigger LLC · Wilmington, DEBuilt 1979 · S/N R18201366 N4649TNew York Aircam Corp · Woodbury, NYBuilt 1981 · S/N R18201724 N464BFMoore John W · Salome, AZBuilt 2024 · S/N 11-001 N464CMUniversity Of Central Missouri · Warrensburg, MOBuilt 2000 · S/N 17280856 N464CSBank Of Utah Trustee · Salt Lake City, UTBuilt 2022 · S/N 18283164

Back to AD 81-18-04 R2