Skip to content

Registered aircraft · 20,683

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.

N4363RSky Walker Flight School LLC · Adrian, MIBuilt 1974 · S/N 17263114 N4365LPriem Ben · Linwood, MIBuilt 1966 · S/N 17254440 N4365QJackson Rickey L · Edmond, OKBuilt 1971 · S/N 17260265 N4365RCsa Aircraft Leasing LLC · Salt Lake City, UTBuilt 1974 · S/N 17263116 N4366RHyland Mark R · Poland, MEBuilt 1974 · S/N 17263117 N436AGSkywest Leasing Inc · St George, UTBuilt 2014 · S/N 172S11457 N436CAWingsleasing LLC · Wichita, KSBuilt 2017 · S/N 172S12061 N436PWRegistration Pending · Walnut, CARegistration pendingBuilt 2023 · S/N 172S13044 N436RMRocky Mountain College · Billings, MTBuilt 1979 · S/N 17273662 N436SPHillsboro Aero Academy LLC · Hillsboro, ORBuilt 2001 · S/N 172S8769 N436THSnohomish Flying Service Inc · Snohomish, WABuilt 2020 · S/N 172S12436 N4370LAir North Flying Club · Malone, NYBuilt 1966 · S/N 17254447 N4370RSkar Paul R · Londonderry, NHBuilt 1974 · S/N 17263121 N4371LPrisk Jack J · Pride, LABuilt 1966 · S/N 17254448 N4373LWilliams Matthew W · Fort Walton Beach, FLBuilt 1966 · S/N 17254450 N4374QWillaero LLC · Union City, TNBuilt 1971 · S/N 17260274 N4376QFranke Russel G · Silt, COS/N 17260276 N4377QStacey James · Exeter, MEBuilt 1971 · S/N 17260277 N4377RDallas Aero & Sales LLC · Poplar, MTBuilt 1974 · S/N 17263127 N4378LRegistration Pending · Wentzville, MORegistration pendingBuilt 1966 · S/N 17254457 N4378QWings Flying Club Inc · South Bend, INBuilt 1971 · S/N 17260278 N4379QHagaman Edward T · Tolland, CTBuilt 1971 · S/N 17260279 N4379RSlipstream Aviation LLC · Calera, ALBuilt 1974 · S/N 17263129 N437EPAb Prop Plane II LLC · Metairie, LABuilt 2015 · S/N 172S11605 N437FAWhiskey Charlie Aero LLC · Poway, CABuilt 2003 · S/N 172S9437 N437PHHolske Peter John · Dartmouth, MAS/N 17267933 N437PSWest Michigan Aviation Academy · Grand Rapids, MIBuilt 2006 · S/N 172S10263 N437SPN437sp LLC · Manassas, VABuilt 1999 · S/N 172S8309 N4381QAero Wise Services LLC · Decatur, TXBuilt 1971 · S/N 17260281 N4381RDugan James M · North Bend, OHS/N 17263131 N4382LFielding Gregory J · Holland, MABuilt 1966 · S/N 17254461 N4382QLegends Air LLC · Wilmington, DES/N 17260282 N4382RMoranski Joseph F · Budd Lake, NJBuilt 1974 · S/N 17263132 N4383LHasman Robert B · Flushing, MIS/N 17254462 N4383QBladen Aviation Inc · Elizabethtown, NCBuilt 1971 · S/N 17260283 N4384QMorten John E · Larimore, NDBuilt 1971 · S/N 17260284 N4384RAmerican Patrols Inc · Midland, TXBuilt 1974 · S/N 17263134 N4385QKulis Richard W · Gill, MABuilt 1971 · S/N 17260285 N4385RAnderson Kenneth J · Norman, OKBuilt 1974 · S/N 17263135 N4386RFlying H LLC · Lake Placid, FLBuilt 1974 · S/N 17263136 N4387QCrose Merrill L · Sibley, MOBuilt 1971 · S/N 17260287 N4388RSunrise Aviation Inc · Ormond Beach, FLBuilt 1974 · S/N 17263138 N4389LOdell John J · Salinas, CABuilt 1966 · S/N 17254470 N4389QMellinger Jason C · North Pole, AKS/N 17260289 N438ERMorey Airplane Company Inc · Middleton, WIBuilt 2001 · S/N 172S8934 N438SCAlpha Charlie Aviation LLC · Oregon City, ORBuilt 2018 · S/N 172S12225 N4390LAero Science International LLC · Martinez, GABuilt 1966 · S/N 17254471 N4390QFlying Mermaid LLC · Aiea, HIBuilt 1971 · S/N 17260290 N4390RBrown David R · Kent, WABuilt 1974 · S/N 17263140 N4390VNamtvedt Erik · Wasilla, AKBuilt 1956 · S/N 28741

Back to AD 90-06-03 R1