AD 65-19-02
Registered aircraft · 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:65-19-02')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:65-19-02')
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:65-19-02') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:65-19-02') 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.
N1402LRaskin Michael · Henderson, NVN1406LBrainerd Philip S · Lake Placid, FLN1409LMusketeer Flying Club LLC · Plano, TXN1414LBrown Joseph T · Saginaw, MIN1417LBright David P · Wachapreague, VAN1423LMedi Carriers Of Wisconsin Inc · Greenville, WIN1426LMartin Michael D · Decatur, TXN1431LJke Family Fun Entertainment Inc · Searcy, ARN1432LStrydom Cornelis F · Liberal, KSN1434LPost Greg G · Mapleton, KSN1436LDelis Costa Z · Heyburn, IDN1441LSayre Jeremy Q · Livonia, MON1444LClifton Gary R · Fowler, INN1450LByrd Aviation LLC · Marshfield, MON1462LSchneider Matthew B · Laughlin Afb, TXN1463LSpears Martin J · Havelock, NCN1465LLoehr Fred A III · Rio Rancho, NMN1466LSteel Randy W · Madras, ORN1468LCh Repairs LLC · Statesboro, GAN1470LAl-Rubaiie Haider A · Fort Worth, TXN1471LLee Michael Jason · Berryville, VAN1475L2328 Charlie Victor LLC · Richmond, KYN1477LCooper Jonathan Thomas · Tempe, AZN1478LBaline Lonny R · Harleysville, PAN1481LOsceola Aviation Services Inc · Lake City, FLN1487LSheets Mark W · Chugiak, AKN1492LSalzer Mychael D · Coulterville, ILN1498LWheaton Blake L · Atlanta, GAN1499LHicks Philip R Jr · Knoxville, TNN1963FSarna David E · Manawa, WIN2063XKimbrough Paul E Jr · Saint Cloud, FLN222BBMatz Jeremy L · Toston, MTN2300JRadosevich Michael K · Albuquerque, NMN2300LAv8n Idaho LLC · Greenleaf, IDN2301LMuskrat Flying Club LLC · Orlando, FLN2301ZRegistration Pending · Maumee, OHRegistration pendingN2302ZJohnson Melvin L · Toney, ALN2303QVan Hoosen Ronald L · Goldsby, OKN2303ZBeech Aero Club · Ashburn, VAN2304LJohnson Diversified LLC · East Lansing, MIN2304QAviation Business Corp · Saint Louis, MON2306QVanderwielen Joseph M · Neenah, WIN2307LZamel Andre · Sunrise, FLN2307QWinters Jeffrey · Olathe, KSN2308JMcgary Blaine J · Pasco, WAN2309QBorja Nicholas F · Freeburg, ILN2310JRegistration Pending · Aberdeen, SDRegistration pendingN2310QPeterson Kevin · Roseville, CAN2311QHagy Thomas Lee · Abingdon, VAN2312LSumerau Robert L IV · Lexington, SC
Back to AD 65-19-02