AD 94-05-05 R1
Registered aircraft · 26,230
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.
N90LLPate Donald P Trustee · Edmond, OKN90PPN90pp LLC · Titusville, FLN90RLBarrett Patricia · Arroyo Grande, CAN90SQMills Christopher D · Brookshire, TXN90TNMike Rinker Aircraft LLC · Union City, TNN9100ARettzo Bernard J · Chandler, AZN9101UAura LLC · Elsie, MIN9101YSafeflite Aviation LLC · Glenwood, IAN9103UMonica Aviation LLC · Cambridge Springs, PAN9105AHerr Andrew A · River Ridge, LAN9105BVeretto Michael A · Odessa, TXN9106ARegistered aircraftN9106BRegistered aircraftN9106USpafford Luke · Pontiac, ILN9107BGrace Community Church · Fremont, OHN9107UAnderson Christopher · Janesville, WIN9108AHendrickson Larry L · Chester, MTN9108URegistration Pending · Studio City, CARegistration pendingN9109ADra Classic Aircraft LLC · Gravette, ARN9109UBrotherson Brian C · Independence, KYN910DCClair Daniel · Loraine, ILN9110ASmith Sidney R · Rllng Hls Est, CAN91111Strawn Dale L · Live Oak, FLFirst renewal noticeN9111UKingdom Air Corps Inc · Sutton, AKN9112BFosgate Helen Hines · Bogart, GAN9112UOstrander William P · Millerton, PAN9113AMulqueen John · Fort Wayne, INN9113BBrown David L · Spring City, TNN9114AHayes Sean M · Kodiak, AKN9114UMarek John M · Tucson, AZN9114ZLarson Richard W · Sioux Falls, SDN9115BParker Justin S · Elko, NVN9115UWigley Ben F Jr · Huntington, ORFirst renewal noticeN9116BS Dacy Enterprises Inc · Harvard, ILN9117BPartridge John R · Manchester, NHN9117UBahr Timmy A · Crandon, WIN9118BCulpeper Aviation LLC · Queen Creek, AZN9118U9118u LLC · Dover, IDN911HGGibson Robert L · Murfreesboro, TNN9121ECunningham Frank D · Okeechobee, FLN9123BStockton Clifford A · Anchorage, AKN9124AWest Kevin B · San Antonio, TXN9126ARehm William J · Bluffton, OHN9126EAlajoki Roger W · Menahga, MNN9127ABehrens Gary K · Slidell, LAN9127BBassham Rick D · Bluff Dale, TXN9128AAl-Banna Reyadh David · Huntingtown, MDFirst renewal noticeN9128RExtraspecial LLC · Wilmington, DEN9128UHarrell Brian · Donalsonville, GAN9129BBoughroum Youssef · Grovetown, GA
Back to AD 94-05-05 R1