Skip to content

Registered aircraft · 20,481

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:84-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:84-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:84-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:84-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:84-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:84-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.

N705EFEverett Farr 182 LLC · Lewes, DEBuilt 2025 · S/N 18283300 N705RStatewide Contract Services LLC · Lowell, ORBuilt 1986 · S/N R-18202037 N706Old Aire LLC · Bellingham, WABuilt 1960 · S/N 50865 N70607Walsh Dennis A · Dakota City, NEBuilt 1968 · S/N 18259323 N70609Gospel Ministries International · Mc Donald, TNBuilt 1968 · S/N 18259325 N70616Washburn Darlene J · Newberg, ORBuilt 1968 · S/N 18259326 N70617Mcnutt John W · Seattle, WABuilt 1968 · S/N 18259327 N70618Allen Steven P · Flagstaff, AZBuilt 1968 · S/N 18259328 N7062Carvagno Lawrence · Trinity, ALS/N 18260264 N70625Resong Joseph J · Garden Grove, CABuilt 1968 · S/N 18259331 N70632Galion Air Inc · Galion, OHBuilt 1968 · S/N 18259332 N70633North County Flying Club · Tehachapi, CAFirst renewal noticeBuilt 1968 · S/N 18259333 N70634Sowry Myron E · Phillipsburg, OHBuilt 1968 · S/N 18259334 N70635Sitatunga Springs LLC · River Hills, WIBuilt 1968 · S/N 18259335 N70649Carroll Aviation Inc · Carroll, IABuilt 1968 · S/N 18259341 N70651Sale Reported · Lakewood, COSale reportedBuilt 1968 · S/N 18259342 N70655Kusterer James E Jr · Nampa, IDBuilt 1968 · S/N 18259343 N70657Cobra Kai Inc · Wichita Falls, TXBuilt 1968 · S/N 18259344 N70658Vroom David H · Oro Valley, AZBuilt 1968 · S/N 18259345 N7065JAmendt Inc · Sedgwick, COS/N 18257772 N7067BMcdonald John M · Lyons Falls, NYFirst renewal noticeBuilt 1973 · S/N 18052367 N70686Haase Douglas R · Manassas, VABuilt 1968 · S/N 18259356 N70688Roesner David A · Salina, KSBuilt 1968 · S/N 18259358 N70695Tucker Whitney L · Gove, KSBuilt 1968 · S/N 18259360 N70697Whalen Charles R · Gladewater, TXS/N 18259362 N70698Martin Kenneth R · Mill Creek, WABuilt 1968 · S/N 18259363 N7069USmith Alwyn · Boca Raton, FLS/N 18051846 N706CPCivil Air Patrol · Maxwell Afb, ALS/N 18281704 N706HPFlorida Highway Patrol · Tampa, FLBuilt 1985 · S/N R18202013 N706PREvoaviation LLC · Watkinsville, GABuilt 1971 · S/N 18260752 N70710Embyr November LLC · Gunnison, COBuilt 1968 · S/N 18259364 N7073SWaterman Ronald L · Albuquerque, NMBuilt 1976 · S/N 18265059 N70740Sierra Bravo Air LLC · Winston Salem, NCBuilt 1968 · S/N 18259365 N7074QMorris Sidney H · Kenai, AKFirst renewal noticeBuilt 1963 · S/N 18051250 N70771Golike Robert E · Eagle River, AKBuilt 1960 · S/N 52397 N70778Engleman Aviation LLC · Comfort, TXBuilt 1968 · S/N 18259366 N70788Mercier Michael S · Chugiak, AKBuilt 1970 · S/N 18052117 N707BSConboy Enterprises LLC · Lexington, KYS/N 18253773 N707CDPadilla Luis Antonio Jr · Brownsville, TXBuilt 1963 · S/N 21058207 N707CTShaak John C · Newnan, GABuilt 1978 · S/N R18200320 N707ERCrossbrook LLC · Willoughby, OHBuilt 1977 · S/N 21062337 N707FSky Magic Aviation Inc Trustee · Wilmington, DES/N 18281081 N707KVieques Aero Club LLC · Ouray, COBuilt 1963 · S/N 205-0439 N707KWWaters Aero Marine Inc · South Thomaston, MEBuilt 1975 · S/N U20602619 N707MGTawoda Leanne · Sun City, AZBuilt 1959 · S/N 52073 N707WCAcp Aviation LLC · Oakdale, LABuilt 1973 · S/N 18052347 N707WJLandry Don T · Thousand Oaks, CABuilt 1977 · S/N U20604054 N70800Gangloff William A Jr · Frederick, MDS/N 18259367 N70802Brandvik Pipe & Equipment Inc · Borger, TXBuilt 1968 · S/N 18259369 N70804Fanning Fred W · Fairlawn, OHBuilt 1968 · S/N 18259370

Back to AD 84-10-01 R1