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.
N3005XOso Air LLC · Missoula, MTN30066Mason Scott C · Lebanon, ORN3006ASouthern Aircraft Consultancy Inc Trustee · Casper, WYN3006SGrice Warren A · Marshall, ARN3006XRegistration Pending · Scottsdale, AZRegistration pendingN3007AFly8ma LLC · Big Lake, AKN3007CGrassroots Avco LLC · Statesville, NCN3007GGregory Vernon L · Swansea, SCN3007XKelley Keith B · Forney, TXN3008NForthofer Richard · King Salmon, AKN3008XAdams Harold L · Beaver, OHN30094Sprott Ray W · Perkins, OKN3009ARoberts Stephen · Camas, WAN3009GGregory Vernon L · Swansea, SCN3009SRegistration Pending · Arlington, TXRegistration pendingN3009XWarren Jeremy I · Horse Cave, KYN300KBBailey Stephen M Trustee · Lawton, OKN300KZDependable Aviation LLC · Cartersville, GAN300YWShell John E · Waverly, OHN3010UWestfly LLC · Kalispell, MTN3010VMurillo George A · Fremont, CAN3011ACooper Remel R Jr Trustee · Green Cove Springs, FLN3011JGonzalez Jose E · Arecibo, PRN30125Ladd Robert · Rock Rapids, IAN3012GGordon Joey D · Llano, TXN3012JTubens Robert Neal · Benton City, WAN3012SMarshe Aviation LLC · Upland, CAN3012XByrne Matthew A · West Allis, WIN3013ADyer Dennis P · Otis, MEN3013SRunge Robert H · Sidney, NEN3013XGreeneway Charles G · Armour, SDN3014JDodd Ethen D · Jack, ALN3014KSzostak Edward M · San Diego, CAN3015JWest Aviation LLC · Astoria, ORN3015NLepley Philip R · Bothell, WAN30168Devine Evan C · Carmel, INN3016APerry Aeronautical Services LLC · Albuquerque, NMN3016GLucas Daniel J · Collinsville, TXN3016SBartholomew Dana C · Madison, WIN3016UValley Wings Flight School LLC · Harlingen, TXN3017AService Oriented Aviation Readiness (Soar) · Bolivar, MON3017JColeman John C · Mc Alpin, FLN3017NJohnson Kyle J · Albert City, IAN3017URivera Michael R · Magnolia, TXN3017XMunson Timothy G · Mendota, ILN3018JHargraves Richard N · Clarksville, ARN3018NRuby Mark A · Conway, SCN3018XWard David J · Garden Valley, IDN3019AWassenaar John W · Venice, FLN3019JRhinelander Flying Service Inc · Rhinelander, WI
Back to AD 94-05-05 R1