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.
N3597VMcleod Patrick J · Overgaard, AZN3597ZWallis Jeffrey D · Greenfield Twp, PAN35986Garst Charles L · Watson, MON3598CN3598c LLC · Ellisville, MON3598JMclaughlin George F · Kennesaw, GAN3598LBryan Aviation LLC · Peoria, AZN35999Kline Paul · Brooklyn, MIN3599SRichner Dennis M · Andover, MNN3599VMakee Markus · Painesville, OHN35CDewey James M · Santa Paula, CAN35DFRoot Monty E · Lehigh, KSN35KBLewis Charles A · Winterville, NCN35PCHutchison Gil F · Salem, ORN35RJEarles Kenneth D · Crowley, LAN35SVImes Thomas E · Bixby, OKN35THDull Thomas C · Los Angeles, CAN35XXGroot Azarja · Lakehills, TXN3600SRussell Scott Marvin · Sanger, TXN3600VTourt Jeffrey S · Yorkville, ILN3602HSale Reported · Jadwin, MOSale reportedN3603LBeardsley David A · Arlington, WAN3603SBetter Fly Inc · Litchfield, ILN3603VOwen Bertha C · Port Saint Lucie, FLN3604ECollier-Sanuki J Scott · Fairbanks, AKN3604JSmtm Holdings Inc · Wilmington, DEN3604VLindsey Roy W · Quinlan, TXN3605JBon Investment Holdings LLC · Zephyrhills, FLN3605LUnger Aviation LLC · Saint Clair, MIN3605NMilne Jeff J · Lake Geneva, WIN3606JElite Fleet Jacksonville LLC · Jacksonville, FLN3606VAimrich Enterprises Inc · Wilmington, DEN3607JSmith Zachary L · Piedmont, SCN3607VDel Vecchio Thomas L · Middlebury, INN3608JSwartzentruber Thomas L · Oakland, MDN3609SSchuerch Vincent M · Wasilla, AKN3609VSidney Aviation LLC · Sidney, NEN360CCKoelbl Michael · Whitesboro, TXN3611JShannon James P · Vandergrift, PAN3611LVick Garland L · Benton, ARN3611SCombs Charles M · Mesa, AZN3612LClean Waste Solutions LLC · Indianapolis, INN3612THamill Theo W · Durango, CON3612VBenjamin Scott T · Estherville, IAN3613JBatista Brasil Vagner · Orlando, FLN3613SMccomb Charles D · Cypress, TXN3613VMcwilliams Eric T · Medina, OHN3614Yokosawa Kenneth Eino · Grand Blanc, MIN3614JSikveland Beau D · Circle, MTN3614LHarris Danny R · Winnsboro, TXN3615KDuke Jimmy · Isola, MS
Back to AD 94-05-05 R1