AD 94-05-05 R1
Registered aircraft · 26,231
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
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:94-05-05-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:94-05-05-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:94-05-05-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:94-05-05-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.
N5490CJenkins Dayne Vaughn · Anchorage, AKN5491RSingh Jaspal · Sacramento, CAN5491TAlpha Mike LLC · Stoughton, MAN5492CSorensen Bjarne K · Vero Beach, FLN5492QMarchant Colby Z · Hazlehurst, GAN5492TCollins Terry D · Maynardville, TNN5493CHetchler Glenn A · Erie, CON5493FBowen John W · Kenai, AKN5494FMullen Andrew P · North Miami Beach, FLNon-citizen corporation, flight hours not reportedN5495CWallace Tracy C · Santa Rosa, CAN5495FMeyer Daniel L · Norfolk, NEN5495RLee Ernest J Jr · Danielson, CTN5496QPhillips Michael · Bossier City, LAN5496RFitzgerald Douglas A · Stockton, CAN5497FJacques Denis A · Weirsdale, FLN5497KLee Myles W · Erie, CON5498QAtlanta Technical College · Atlanta, GAN5498RWilson Dale L · Escalante, UTN5498TSale Reported · Lewes, DESale reportedN5499CJohnson Linzy A · Lake Stevens, WAN549KJames Justin C · Palmer, AKN549LLCc Aviation Inc · Tracy, CAN549PUBerkey Aviation LLC · Lafayette, INN549VDuffy Justin R · Livingston, MTN54GCWilson Karlton M · Craigmont, IDN54HHGrillot Michelle L · Kannapolis, NCN54JGKong Trudith A · Auburn, WAN54MLJordan James L · Las Vegas, NVN54QWeaver David A · Hamilton, OHN54THHearn Tim L · Creola, ALN5500HMaxwell William P · Port Orange, FLN5500TOhair Ronald L · Pasco, WAN5501EMoffer Donley K · Grapevine, TXN5502GKeeven Diana F · New Smyrna Beach, FLN5502TMartin William G · Mc Clellandtown, PAN5503TAivia Aviation LLC · Estes Park, CON5504CLevsen Daniel C · Clarence, IAN5504RAerocareers Nfp · Columbia, ILN5504TLam Pak To · El Monte, CAN5505EBarnwater Development Inc · Ardmore, OKN5505GOsterhaus Nolan · Blair, NEN5505RMerritt Island Flying Club Inc · Merritt Island, FLN5505XDuff Trent H · Warrenton, MON5506GSanchez Carlos D · Ashburn, VAN5506RAnderson Interests LLC · East Bernard, TXN5506TMorgan Ronnie · Keller, TXN5507CAnderson Michael J · Carmichael, CAN5507EFritsch Raymond H · Galesville, WIN5507GBates Nicholas · Lawton, OKN5507TBlue Feathers Corp · Newark, DE
Back to AD 94-05-05 R1