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.
N9401HConstantine Costas T · Newington, CTN9402CMontgomery Robert L · Port Angeles, WAN9402DH C E Leasing LLC · Cleveland, TNN9402UMayrant Dawson Z · College Station, TXN9402XSewell John · Sugar Grove, ILN94035Husbands David · Bosque, NMN9403AJ & K Flying LLC · Marengo, OHN9403CDobson Michael W · Konawa, OKN9403UPaschal Engineering Inc · Houston, TXFirst renewal noticeN9403YFlorida Emergency Management Associations Inc · West Palm Beach, FLN9404AMorrison Mark C · Marfa, TXN9404BRutledge Dianna G · Winder, GAN9404CBergh Gene H · Roberts, WIFirst renewal noticeN9404FBas Part Sales LLC · Greeley, CON9404HSowell Richard G · San Jose, CAN9404UWhitcomb James F · West Ossipee, NHN94059Moriarty Gerald J · Anchorage, AKN9405ACronin John W Jr · Denver, CON9405CRamsower Charles M · Parma, IDN9405RJones Lance E · Duncan, OKN9405UBishop Michael E · Clarkston, WAN94061Guinn LLC · Bothell, WAN9406AStowell Colt M · Homedale, IDN9406UMontgomery Paul Richard · Fredericksburg, VAN94077Milky Way LLC · Fresno, CAN9407CTyrrell Richard E · Central, AKN9407HB2w Corporation · Winona, MNN9407TBodin Logan T · Lake Charles, LAN9407XDriggers Kenneth Jerry · Rialto, CAN9408ADill Steven S · Hesperia, CAN9408HWanamaker Jeffrey Cass · Fall City, WAN9408LMccallum David DBA · Napa, CAN9408UTenhoff Lee L · Homer, AKN9409LLaguna Verde Leasing Inc · Wilmington, DEN9409TBas Part Sales LLC · Greeley, CON9409UFree Wade · Sharon, OKN9409XEnergy Transfer Aviation LLC · Spring, TXN940AMOracle Aviation LLC · Omaha, NEN940CPCivil Air Patrol · Maxwell Afb, ALN940FSYogini Modi · Homestead, FLN940HPKansas Highway Patrol · Topeka, KSN940MAMoore Charles H · Richmond, TXN940RMSchool Of Missionary Aviation Technology · Ionia, MIN940WSkyhawks Inc · Westminster, CON9410AAllen Dennis R · San Mateo, CAN9410MWomack David H · Rayville, LAN9410XHendrix Philip R · Corpus Christi, TXN9411ARenkenberger James H · Saint Joe, INN9411HFeaga Charles C · Abbot, MEN9411LCivil Air Patrol Inc · Maxwell Afb, AL
Back to AD 79-10-14 R1