Skip to content

AD 2009-10-09 R2

Registered aircraft · 8,565

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:2009-10-09-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:2009-10-09-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:2009-10-09-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:2009-10-09-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:2009-10-09-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:2009-10-09-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.

N5391QMja Aviation LLC · Channahon, ILBuilt 1972 · S/N 15073291 N5392QLatitude Aviation LLC · Cedar Rapids, IAS/N 15073292 N5394BRichmor Aviation Inc · Hudson, NYBuilt 1979 · S/N 15283859 N5395QOwens John C · Mount Carmel, PABuilt 1972 · S/N 15073295 N5399BLudian Malgorzata · Bakersfield, CABuilt 1979 · S/N 15283861 N539BXin Han Aviation LLC · Atwater, CABuilt 1979 · S/N 15283898 N53PHHaynes Jason Allen · Justin, TXS/N A1500352 N5401QMaine Center For Classic Aviation · Pittsfield, MES/N 15073301 N5403HWings Over Texas Holdings LLC · Denton, TXBuilt 1979 · S/N 15284096 N5403QAbriam Darryl · Dahlgren, VABuilt 1972 · S/N 15073303 N5404BRichmor Aviation Inc · Hudson, NYBuilt 1979 · S/N 15283862 N5405BNatkat Aviation Services LLC · Finleyville, PABuilt 1979 · S/N 15283863 N5405MToozer Air LLC · Ormond Beach, FLBuilt 1980 · S/N 15284581 N5407QR G V Flight Academy LLC · Bayview, TXS/N 15073307 N5409QOwens Anthony G · Kotzebue, AKS/N 15073309 N5412QWilson William W · Mccall, IDBuilt 1972 · S/N 15073312 N5415QBrown James Jr · White Hall, ARBuilt 1972 · S/N 15073315 N5416BLong Island Aviators LLC · Seaford, NYS/N 15283867 N5416QSharp Jacob T · Frankfort, KYS/N 15073316 N5420POklahoma State University · Stillwater, OKBuilt 1981 · S/N 15284942 N5421PRiverside Flight Center Inc · Tulsa, OKBuilt 1981 · S/N 15284943 N5428LMacair Aviation LLC · Xenia, OHBuilt 1980 · S/N 15284313 N5428QKruse Jakob · Parsippany, NJBuilt 1972 · S/N 15073328 N5435QHutchins Kent F · Carbon, INBuilt 1972 · S/N 15073335 N5436QAdler Richard A · Leland, NCBuilt 1972 · S/N 15073336 N5437QMetro Technology Aviation Campus · Oklahoma City, OKBuilt 1972 · S/N 15073337 N543VKHuffman Jacob M III · Burleson, TXBuilt 1969 · S/N 15071227 N5442BWings Over Texas Holdings LLC · Denton, TXBuilt 1979 · S/N 15283870 N5443LCp Aviation Inc · Santa Paula, CABuilt 1980 · S/N 15284315 N5444QChiavari Nicholas J · Havertown, PABuilt 1972 · S/N 15073344 N5447LPinnacle Aviation Services Inc · Encinitas, CABuilt 1980 · S/N 15284317 N5448LSantorini Services LLC · Washington, DCS/N 15284318 N5449QHarper Randall W · Presque Isle, MEBuilt 1972 · S/N 15073349 N5450QCruise Flight Academy Inc · Dalton, GABuilt 1981 · S/N 15285112 N5452QRhein Craig · Mastic, NYBuilt 1972 · S/N 15073352 N5453MQueen City Flying Club LLC · Cincinnati, OHBuilt 1980 · S/N 15284590 N5454QPetko James · Mishawaka, INS/N 15073354 N5458PLoewenstein Edward B · Austin, TXBuilt 1981 · S/N 15284949 N5459JKling Aviation Inc · Friendswood, TXBuilt 1975 · S/N 15077368 N5459QZimmerman Dean F · Royalton, MNBuilt 1972 · S/N 15073359 N5460BSkyway Inc · Wilmington, DES/N 15283875 N5460QJacobson Eric R · Ouray, COS/N 15073360 N5461HWhitson Johnny E · Cleveland, TXBuilt 1979 · S/N 15284102 N5464PDanig Aviation LLC · Newark, NJBuilt 1981 · S/N 15284951 N5464QBinsfeld Thomas · Chico, CABuilt 1972 · S/N 15073364 N5465QWhitford John T · South Weber, UTBuilt 1972 · S/N 15073365 N5466QDe Sciscio Salvatore A · Chaplin, CTS/N 15073366 N5470QBuiqui Aerospace Corp · Kissimmee, FLNon-citizen corporation, flight hours not reportedBuilt 1972 · S/N 15073370 N5471QGunnarsson Jon · Concrete, WABuilt 1972 · S/N 15073371 N5472QAmf Diversified LLC · Mesa, AZS/N 15073372

Back to AD 2009-10-09 R2