Skip to content

Registered aircraft · 20,687

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:90-06-03-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:90-06-03-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:90-06-03-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:90-06-03-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:90-06-03-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:90-06-03-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.

N84183Chickadee Aviation LLC · Burr Ridge, ILBuilt 1969 · S/N 17258368 N84185Harrison Gene R · Pendleton, ORS/N 17258348 N84186Gould George Jr · Bryantville, MABuilt 1969 · S/N 17258369 N84190Frs & Craig Llp · Byron, GABuilt 1969 · S/N 17258371 N84193Smirnov Alexei · Fair Lawn, NJBuilt 1969 · S/N 17258372 N84194Ultra Aviation LLC · Cedar Bluff, VABuilt 1969 · S/N 17258373 N84195Norcal Flight Center LLC · Lincoln, CABuilt 1969 · S/N 17258374 N8419USweeney Building Co · Lakeview, ORS/N 17252319 N841JARicci Theodore J · Spotswood, NJBuilt 1968 · S/N 17256902 N841JWScenic Concepts LLC · La Crosse, WIBuilt 1974 · S/N 17264340 N841KSKansas State University · Salina, KSBuilt 2022 · S/N 172S12805 N841SPRandolph Macon Academy · Front Royal, VABuilt 2001 · S/N 172S8746 N8420LHayhurst Shane R · Winfield, PABuilt 1968 · S/N 17256620 N84210Pm Jets LLC · Ashland, OHBuilt 1969 · S/N 17258380 N84214Planefully Obvious LLC · Oshkosh, WIBuilt 1969 · S/N 17258382 N8421USky Falcon LLC · Syracuse, NYS/N 17252321 N84221Mcknight Michael D · Marietta, GABuilt 1969 · S/N 17258384 N84224Cordes Jeffrey A · Happy Valley, ORBuilt 1969 · S/N 17258386 N84225Executive Flight Institute LLC · Murrieta, CABuilt 1969 · S/N 17258387 N84226Jackson County Aviation LLC · Sneads, FLBuilt 1969 · S/N 17258388 N84229Langenbahn Theodore John · Schoharie, NYBuilt 1969 · S/N 17258389 N8422LHubert Kim J Trustee · Eagle River, AKBuilt 1968 · S/N 17256622 N8422XDundee Flying Club Inc · Rock Stream, NYBuilt 1961 · S/N 17248922 N84234Mazelg Aviation LLC · Bartow, FLBuilt 1969 · S/N 17258390 N8423LYoung James A · Toledo, WAS/N 17256623 N84243Sjoberg Donald E · Poteau, OKBuilt 1969 · S/N 17258393 N8424LMcgreen John R · Albany, NYBuilt 1968 · S/N 17256624 N8424XHarvey Barrett K · Robstown, TXBuilt 1961 · S/N 17248924 N84250Wick James R · Canon City, COBuilt 1969 · S/N 17258395 N84256Registered aircraftBuilt 1969 · S/N 17258396 N8425XGarzione John E · Sherburne, NYBuilt 1961 · S/N 17248925 N84265West Gerald Lee · Two Harbors, MNBuilt 1969 · S/N 17258399 N84267Shields Debra M · York, SCBuilt 1969 · S/N 17258400 N84271Anderson Operations LLC · Fallon, NVBuilt 1969 · S/N 17258402 N84275Rodriguez Norberto R · Inwood, NYBuilt 1969 · S/N 17258404 N84278Ap Air LLC · Wilmington, NCBuilt 1969 · S/N 17258405 N8427UCoulombe Michael J · Lunenburg, MABuilt 1964 · S/N 17252327 N84289Angelov Ruslan P · Mount Prospect, ILS/N 17258410 N84293Nwa Flyers LLC · Missoula, MTBuilt 1969 · S/N 17258411 N84299Phoenix Aviation Holdings LLC · Crystal Beach, FLS/N 17258413 N8429UHomrich Paul R · Maybee, MIBuilt 1964 · S/N 17252329 N842EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2024 · S/N 172S13193 N842KPLewis University · Romeoville, ILBuilt 2005 · S/N 172S9849 N842KSKansas State University · Salina, KSBuilt 2022 · S/N 172S12806 N842LPJet Air Inc · Iowa City, IABuilt 2001 · S/N 172S8842 N842RBLowcountry Flight LLC · Johns Island, SCBuilt 1969 · S/N 17258377 N842SAJet Air Inc · Iowa City, IABuilt 2000 · S/N 172S8448 N842SPSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2001 · S/N 172S8747 N842WBGiesbrecht Nolan R · Burns, ORBuilt 1958 · S/N 36665 N84309Mcgee David · West Monroe, LABuilt 1969 · S/N 17258417

Back to AD 90-06-03 R1