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.
N5843EMedlin Wayne D · Marshville, NCFirst renewal noticeN5844GLummus David R · West Point, MSN5845GBerg William J · Aberdeen, SDN5846AHalford Richard W · Eagle River, AKN5846ESale Reported · Ohatchee, ALSale reported, pending cancellationN5847ACochran Josh · New Orleans, LAN5848GDerby City Aviation LLC · Vero Beach, FLN5849AAllison Michael L · Lubbock, TXN5851RSmoky Bear Air LLC · Rockwood, TNN5852GSwigart Davis Holdings Inc · Upland, CAN5852RBenien Dennis A · Napoleon, OHN5853ADanz Frederick C · Mattawa, WAN5853GJohnson Robert K · Monte Rio, CAN5853RHall Gary M · Muncie, INN5855RDonelan Matt B · Springfield, ILN5856EBudde Bobby Jr · San Jose, CAN5857ABrandt Jeff D · Ankeny, IAN5857GWhitver Jeremy W · Ankeny, IAN5857RWaypoint Equipment LLC · Mckinney, TXN5858AMadey Benjamin · Ghent, NYN5858RNitz Terry L · Fredericksburg, VAN5859EFee Eamon · Winchester, MAN585SYMolnar Dezso E · Davis, CAN5860ENeary John R · Ridgefield, NJN5860GRegistered aircraftN5860RSkyhawk Ventures LLC · Boise, IDN5861ETeets Trent D · West Fargo, NDN5862ASanders Mark R · Towner, CON5862RMcgowan Keegan M · San Antonio, TXN5863ADabney Richard W · Tanner, ALN5863EAj Financial LLC · Sachse, TXN5864AS Aviation LLC · Wisconsin Dells, WIN5864GScarabin Jim D · Apalachicola, FLN5864RBattle Proven Leadership LLC · Crown Point, INN5866AChipman Jeffrey M · Rising Sun, INN5866EUrban Performance · Newark, OHN5866RNeal Edward K · Laud By Sea, FLN5867AUrciuoli Salvatore · Holbrook, NYN5867CGunnarsson Jon · Concrete, WAN5867GCrowley Kelly P · Mount Pleasant, SCN5867RGoatley John E · Springfield, KYN5868RRizzo John M Sr · Sugar Land, TXN5869AHurt Wally · Amboy, WAN5869EWells Dave · Nampa, IDN5870AGlenn Chester L · Hugo, OKN5872GCramer John A · Marana, AZN5872RMckee Joseph R · Godfrey, ILN5873AWilemon Stephen L · Tulsa, OKN5873R3 Points LLC · Comstock Park, MIN5874AShaha Zachary D · Menomonie, WI
Back to AD 94-05-05 R1