AD 94-05-05 R1
Registered aircraft · 26,232
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.
N8254ABerna Glen F · Pulaski, WIN8254LDennard C Alan · Coolidge, GAN8254TBaxter Christopher D · Trimble, MON8254UWolf Nathan · Wishek, NDN8254XHd Security Systems Inc · Watertown, TNN8255FStarks Aviation Inc · Pittsburgh, PAN8255LAllen Shaun M · Lake Ann, MIN8255SConz Gerald Patrick Jr · Wyandotte, MIN8255TVan Hoomissen James · Wasilla, AKN8255XFeik Robert · North Powder, ORN82560Reynolds William J · Griffin, GAN82567Dagnon Paul A · Saint Paul, MNN8256BHanes Ronald J · Bowling Green, KYN8256URegistered aircraftN82572Debt Flying LLC · Holland, MIN8257SCrews Bryce D · Rensselaer, INN8257XGypsy Aero LLC · Darien Center, NYN82588Plyler Aviation Lp · Sherman, TXN8258TStevens Scott D · Corsicana, TXN82594Four C Sons Inc · Kersey, CON8259FCoker Nathan F Jr · Lynchburg, VAN825DCMcdaniel Ronnie J Sr · Starkville, MSN825GRResh Gerald A · Fayetteville, ARN825JKeich John D · Saint Louis, MON8260BMatyas Joseph J Jr · Drums, PAN8260USteier William Charles · Inver Grove, MNN8261BDarbro Joel K · Elk City, KSN8262LMclean Corey J · Houston, TXN8262TJohnson Durwood D · Beaumont, TXN8262XBilton Nicholas J · Bozeman, MTN8263BWalton Josh A · Copan, OKN8263THaig Richard J · Lawrence, KSN8264BMcclure Jason L · Hutchinson, KSN8264LMorelock Colleen P · Beavercreek, OHN82653Riggin Flight Service Inc · Madison, SDN82657Irwin Terry H · Gordonille, MON8265LUz Stephanie S · Arlington, VAN8265TBrooks Charles W · Hesperia, CAN8265UHickey Kenneth E · Crossville, TNN82660Stalls Matthew B · Denver, CON8266BHickson Benjamin J · Melbourne, FLN8266FOnemanconcrete LLC · Thaxton, VAN8266SRankin Gregory E · Wetumpka, ALN8266TSrock Charles L K · Alexandria, MNN8267AWendt Clayton L · Lino Lakes, MNN8267FPokorny John · Woodstock Valley, CTN8267LInverted Aviation LLC · Atascadero, CAN8267TGatewood Keith Alan · Albuquerque, NMN82680Hoffman Edward C · Tarpon Springs, FLN82686Boucher Kenneth G · Scotland, CT
Back to AD 94-05-05 R1