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.
N72687Registration Pending · Peru, MERegistration pendingN7268HTimoszyk Daniel M · Belleville, MIN7268TParker Harold E · Cabot, ARFirst renewal noticeN72691Davis Herbert W · Danville, ARN72693Obritsch Monte R · Malcolm, NEN72699Cope Samuel A · Lamesa, TXN726HBDeatherage Tony · Goshen, OHN726KKlementovick Frank L · Montoursville, PAN72705Adasiewicz William F J · Redwood City, CAN7270TBudenbender Philip W · Weatherford, TXN72712Cook Robert M · Gainesville, GAN72715Ursitti James III · Beaver, PAN72717Hoppers Danny C · Osceola, MON72719Longino Justin E · Troutman, NCN7271AEinck Matthew J · Fort Worth, TXN7271SWalker Kevin · Stillwater, OKN72720C140 LLC · Lewes, DEN72721Smalley Roger A · Medford, ORN72726Friedman Jared D · Green Cove Springs, FLN72728Lake Alexis S · Lititz, PAN7272AOpen Air Ltd Co DBA · Pella, IAN7272KPearson Zachary B · Hayden, IDN7272SRegistered aircraftN72732Houston Jerry M · Hickory, NCN72733Lee John Y · Covina, CAN72737Hogan Robert P · North Pole, AKN72739Blythe Anne T · Paso Robles, CAN7273AMartin Randal O · Oak Point, TXN7273DWheatland Aviation LLC · Clark, SDN7273SFerguson Jeffrey Woods · San Antonio, TXN72740Lyons Andrew James · Mansfield, MAN72741Gibson Roderick J · Blairsville, GAN72742Jackovich Vincent B · Eldridge, IAN72744Hiebert Nathan D · Newton, KSN72747Blades Audie · Newman, CAN7274GFlyit LLC · Washougal, WAN7274TN8653u LLC · Fairbanks, AKN7274XFuellner Sean L · Shelocta, PAN72750Dekan Jason S · Eau Claire, WIN72753Kahle Timothy R · Chattanooga, OKN72756Brown Randy S · Wasilla, AKN72757Rich Walter M · Amana, IAN72759Casey Joseph C · Jacksonville, TXFirst renewal noticeN7275AZelinski Jeffrey C · Watersmeet, MIN7275TBeets Larry Joe · Columbia, MSN72769Ritschel Andrew J · San Martin, CAN7276AAved Consulting LLC · Edgewater, FLN7276MMcneil Larry D · Portal, AZN7276SMorgan Michael · Wichita, KSN7276TBraner Richard C Trustee · Oakdale, CA
Back to AD 94-05-05 R1