AD 79-10-14 R1
Registered aircraft · 56,582
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:79-10-14-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:79-10-14-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:79-10-14-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:79-10-14-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.
N7402TKnox David B · Mc Arthur, OHN7402XClemson Flying Club Inc · Seneca, SCN74036Pallen William T · Fargo, NDN7403TKoehn David Scott · Orange Beach, ALN7403WJohnston Aircraft Leasing LLC · Highland, CAN7404MHrevans Cessna 175 LLC · Fairbanks, AKN7404NFmy Aviationllc · Fort Myers, FLN7404TRaptor Flight LLC · Fort Worth, TXN7405GStan And Amy Weyer Aircraft LLC · Punta Gorda, FLN7405XWills Terry W · Cedar Park, TXN7407AKremmling Flying Inc · Kremmling, CON7407GStarr Ralph H · Port Orange, FLN7408AJohnston Lynwood A · Anchorage, AKN7409EDavis Julius E · Theodore, ALN7409GAero Quest LLC D/B/A · Olive Branch, MSN7409TJohnson Scott E · Wausau, WIN740BBellas Business LLC · Kalispell, MTN740BHHarris Jaqai · Juneau, AKN740CPCivil Air Patrol · Maxwell Afb, ALN740DAb Prop Plane II LLC · Metairie, LAN740MHumphrey William A · Grosse Ile, MIN740SBirch Tree Aviation LLC · Unadilla, GAN740SPJet Air Inc · Iowa City, IAN7410EFerguson Thomas H · Springfield, MON7410TLepinsky Donald J · Whitehall, MTN7411ACoverdill Robert E · Savoy, ILN7411ERenshaw Elliott · Lavernia, TXN7411TMcbain Sarah R · West Warwick, RIN7411XTakagi Mark A · Richland, WAN7412ELorraine Aviation LLC · Lewes, DEN7412QTrostad Kari L · Minnetrista, MNN7412SClear Blue Aviation LLC · Hayden, IDN7412TDavis Tonya · Hohenwald, TNN7412XEpperson Gregory R · Grove, OKN7413QMccullough Alfonzo F · Aurora, CON7413TThompson Daniel L · Malta, OHN7414AMutter Wilson T · Chelan, WAN7414MFrenzel Carl O · Midlothian, TXN74150Meyer Tabatha M · Fairview, TXN7415ASmith Kevin L · Peachtree City, GAN7415KClarke Kenneth J · Anchorage, AKN7415XKeenan James F · Neenah, WIN7416AAce Flying Co LLC · Wichita, KSN7416GDreggors David Richard · Altamonte Springs, FLN7416QRobin Alan Olmstead · Yuma, AZN7416TMcalister Donald F Jr · Munith, MIN7416XHarris Terrence J · Killeen, TXN74177Campbell Peter Shane · Knoxville, TNN7417AKoons Bill R · Centerville, MON7417TMcgrath William F Jr · Nantucket, MA
Back to AD 79-10-14 R1