AD 64-04-03
Registered aircraft · 122
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:64-04-03')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:64-04-03')
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:64-04-03') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:64-04-03') 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.
N101F5g Air LLC · Rhome, TXN144BCThomas George E · Rice, WAN2127CRowsey Andrew M · Corinth, MSN223HWChesnut Tara M · Wasilla, AKN2423Dinstel Daniel A · Alzada, MTN432TEEmmons Thomas M · Millington, MIN4831EHardy John R · Wasilla, AKN4832ESenn David L · Oak Ridge, TNN4843EMoody Jerry W · Olympia, WAN4844EGroves Jamie L · Wasilla, AKN4850EGibson Timothy A · Frankfort, KYN4856ERiggin Flight Service Inc · Madison, SDN4866ECollier Charles R · Gloucester, VAN4871ESloss John W · Sterling, AKN4876EFarrell Clifton S · Needville, TXN4879EPappas William B · Dallas, TXN4882EWalker Ray A · Sanger, TXN4883ECarricaburu Elliot A · Wasilla, AKN4885ESharr Ken D · Bigfork, MTN4894EPlyler Aviation Lp · Sherman, TXN49DTClark Coy A · Raeford, NCN510RJSpring Mountain Aviation LLC · San Francisco, CAN5923LKane Christopher M · Sacred Heart, MNN597GCAg-Av8r Flying Services LLC · Brookline, NHN621EHofstetter Michael T · Saint James, MON6231LDelong Thomas S · Fairbanks, AKN650GSDiebel Darrel L · Okanogan, WAN67ZVAircraft Partner Holdings Inc Trustee · BerlinN68KAAakre Keith E · Granite Falls, MNN7158PJinnette James · Raleigh, NCN7411BWilcox Stacy S · Parker, CON7432PWeber William A · Brodhead, WIN7572ENibbe Douglas L · Saint James, MNN7574EWalpierre LLC · Indiana, PAN7575EMajer Vaclav · Monterey, VAN7587EBroderick William E · Sterling, MAN7591EYoung Carl J · Lubbock, TXN7595EFlynn Andrew L · La Grande, ORN777UFTaylor Douglas M · Dallas, TXN808BWWeber William A · Brodhead, WIN836ZRegistered aircraftN84406Mio William A · Intl Falls, MNN848XAnderson Charles E · Fort Worth, TXN8502EJones Derick · Moultonborough, NHN8507ERifenburg Brian K · Ward Cove, AKN8515ERegistered aircraftN8522EHall Robert P · Decatur, ALN8547ECarpenter Lionel Lee · South Fork, CON8549EDrageset Denvero · Isabel, SDN8558EZurinsky Richard · Port Orchard, WA
Back to AD 64-04-03