AD 74-08-01
Registered aircraft · 10,878
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:74-08-01')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:74-08-01')
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:74-08-01') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:74-08-01') 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.
N10HGGerardy Harlan D · Gruver, TXN10HLHoyt Robert H Trustee · Canby, ORN10XCMontgomery Jerry J Jr · Charlotte, NCN10XEBlaikie Thomas B · Kenner, LAFirst renewal noticeN10YSeitz William D · Gordonville, TXN1101CHampton Brock W · Wichita, KSN1102CWakefield Aviation LLC · Mahopac, NYN1102MEls Dennis J · Centralia, ILN1103MFlying M Enterprises · Loomis, NEN1104MCarrolls Auto & Aircraft LLC · Muncie, INN1105CLandon Jeff · Lancaster, CAN1109MPatrick Chris J · Paris, ILN1109USky Quest Inc · Wilmington, DEN110AUHernandez-Santiago Ruben A · Ponce, PRN110BXCk Leasing Services LLC · Wilmington, DEN110CSFlorida Keys Flight Academy LLC · Marathon, FLN110DHYingling Consultation LLC · Wilmington, DEN110DWSlater Spray Service Inc · Maddock, NDN110PFUniversity Of Detroit Flying Club Inc · Livonia, MIN110RLProctor Charles L · Alachua, FLN110SBCreamer Leon Eugene · West Jefferson, OHN110TKSchnorf Curt L · Centerview, MON110USZwainz Thomas G · Reardan, WAN110YDLloyd Clee · Canby, ORN11103Hennigan Shellie · Jonesboro, LAN1110SMob Aviation USA LLC · Kissimmee, FLN11115Crist Steve · Reno, NVN1115UAvian Leasing LLC · Bremerton, WAN11172Skaaire Society · Madison, WIN1117UBhp Aviation · Santa Clara, CAN111BXDonadio Robert F · Amherst, NHN111CJRegan Dennis W · Rochester, MNFirst renewal noticeN111CYSmody Michael S · Neelyville, MON111DEPespisa John · Hacienda Heights, CAN111GFHuggins Stephen M · Eagle Creek, ORN111GTMorgan Gerald W · Hillsboro, TXN111KBSale Reported · Mexico D FSale reportedN111RRCook David C · Orlando, FLN111SA111sa LLC · Greeley, CON111TFPacific Aviation Aircraft Management Inc · Ontario, ORN111TLNdk Global Holdings Corp · Dover, DEN111WLCj Aero LLC · Fort Valley, VAN1120VKodiak Marine Construction · Oakley, IDN11226Box Jon A · Carrizo Springs, TXN1123MGrey Robert J · La Madera, NMN1124MRegistration Pending · West Branch, MIRegistration pendingN1126MD2 Government Solutions LLC · New Bern, NCN11271No Coop Cardinal LLC · Sonoma, CAN1128UElw Inc · Bonners Ferry, IDN1129USchroeder Herbert D · Plano, TX
Back to AD 74-08-01