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.
N8856GMorris Charles K · Miami, FLN8856UKnutson Wayne R · Thompson, NDN88575Taft Aero LLC · Pennington, NJN88579Graves Kenneth D · La Crosse, WIN8857BSafe Skies Aviation LLC · Middletown, OHN88589Mcconnell Bert J · Hudson, OHN8858BPiper Joseph C II · Walsenburg, CON8858SDenney Andrew I IV · Las Cruces, NMFirst renewal noticeN8858UHolbrook Joel P · Delta Junction, AKN8859BRandolph James C · Ridgecrest, CAN8859GBaker Jacob J · Nags Head, NCN885CTFlight Club 502 Inc · Louisville, KYN885DERoberts James A · Hamburg, ARN8860BStraight Tail Flyers LLC · Peoria, ILN8860GBlack Spruce Aviation LLC · Hermon, MEN8861GMiller Andy D · Marana, AZN8861SJump Brian · Watsonville, CAN8861UBlanchard Donald P Jr · Napoleonville, LAN8862SBarber Theodore C Trustee · Spanish Fork, UTN8862UChase Tim W · Kearney, MON8863BMollere Michael E · Marion, TXN8863UBoatman Robert G · Great Falls, MTN88657Stanton Jeffrey J · Camarillo, CAN8865BRegistration Pending · Wentzville, MORegistration pendingN8865GChiquiza Gomez Juan Camilo · Fort Pierce, FLN8865URegistration Pending · Parsons, KSRegistration pendingN88664Gruenwald Stephen · Orland, CAN8866SZimmer Linda S · Hillsboro, ILN8867BCowan Rena E · Pleasant Hill, ORN8867GDavis Robert M · Liberal, KSN8867SCooper-White Michael L · Orrtanna, PAN8867UHoffman Robert E · Blossvale, NYN8868SMeriwether John N · Prairie Village, KSN8868UMuller Robert J · River Falls, WIN88695Johnson Gary I · Minot, NDN88698Farley Douglas C · Edmond, OKN8870ZKinghorn Loran Riley · Wilton Manors, FLN8871Stevens Wayne E II · Denver, CON8871BSing Clifford J Trustee · Idaho Falls, IDN8871GHukill Warren J · Oakland, CAN8871UWichmann William C · Owasso, OKN8872SAeronautical Technical Service Inc · Collierville, TNN8873BPathfinder Aerospace LLC · Raeford, NCN8873GHarris David J · Aguila, AZN8873UOlafsen George F · Greeneville, TNN8874GEluwawalage Damayanthie · Reading, PAN8875UDunaire LLC · Mechanicsburg, PAN8876BBeryl Aviation LLC · Omaha, NEN8877USmith Stephen A · Aloha, ORN8878UBallard Ralph T · Hurricane, UT
Back to AD 94-05-05 R1