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.
N81HWJones Bradley · Farmerville, LAN81JDBarbour Grays Inc DBA · Buckhannon, WVFirst renewal noticeN81KCCraigo Keith A · Addison, TXN81KSChristiansen Aviation LLC · Wilmington, DEN81LAMiller Arland E · Guaynabo, PRN81LBGaravaglia Gary E · Statesville, NCN81LTDob Air LLC · Baiting Hollow, NYN81LWCloud Seven LLC · Fort Pierce, FLN81MPPatriot Aviation Inc · Greenville, DEN81RPLull William G · Ramona, CAN81SCGl Aircraft Enterprise LLC · Wilmington, DEN81TJHelgerson Nicky A · Zwingle, IAN81TPPowers Charles M · Greenwood, MSN81ZHCarlsbad Raceway Corp · Hemet, CAN8200FCallanan Craig E · Stillwater, NJN8200GRj Vincent Enterprises LLC · Rancho Santa Fe, CAN8200SPoms Maxfield David · Groveland, CAN8200XKlad-Air LLC · Catlett, VAN8201FYellott Jerry L Jr · Dequincy, LAN8201GMetzgen Richard A · Groveland, CAN8201LLonghorn Fligh Training LLC · Midlothian, TXN8201SMann Derek W · Burwell, NEN8201ULerma Homero G · Mcallen, TXN8202AWeaver Savannah N · Fortson, GAN8202F98x LLC · Caddo Mills, TXN8202LHorizon Flights Corp · Henderson, NVNon-citizen corporation, flight hours not reportedN8202SBell Tammy L · San Antonio, TXN8202UBudget Flyers · Shreveport, LAN8202VCebulski Barry A · Fairbanks, AKN8202XFerris Tyler S · Pompano Beach, FLFirst renewal noticeN8203AVista Aviation Services LLC · Boone, IAN8203GWarne Samuel S · Salisbury, NCN8203KHandy Air Inc · Douglas, GAN8203MBottle Meister Inc · San Luis Obispo, CAN8204GLowe Clinton V · Lake Point, UTN8204LJohnson Kathy L · Wellsburg, WVN8204TChampion Anthony R · Troy, MON8204USchenck Paul · Glendale, CAN8204XWallace Howard C · Lompoc, CAN8204ZLfs Inc · Ekalaka, MTFirst renewal noticeN8205BHarrison Joseph T · Pensacola Beach, FLN8205FRegistered aircraftN8205SMckay Christopher · Point Arena, CAN8205UDby Flights LLC · Pennock, MNN8205ZMcdaniel George C · Mission Viejo, CAN8206AWalker Jack A · Klamath Falls, ORN8206LPratt Errol C · Fayetteville, GAN8206MMaxon William D · Santa Paula, CAN8206UShortridge Gary F · Dover, TNN8206VRegistration Pending · Wasilla, AKRegistration pending
Back to AD 79-10-14 R1