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.
N808RLCtr Assets LLC · Dawsonville, GAN808TPAvian Leasing LLC · Bremerton, WAN808UFMahoney Clinton D · Tecumseh, NEN808ZTDepartment Of Homeland Security · Washington, DCN80906Red Door Aviation LLC · Dover, DEN80912Bay Area Concrete LLC · Hayward, CAN80914Cp Aviation Inc · Santa Paula, CAN8091AHonrud Joseph C · Cal Nev Ari, NVN8091EChristiansen Aviation LLC · Wilmington, DEN8091GWood Kim W · Tucson, AZN8091LSzarek Carlee B · Los Osos, CAN8091ZFahlbusch Marius J · Snohomish, WAN80921Conerly Group LLC · Denham Springs, LAN80928Bellingham Aviation Services LLC · Bellingham, WAN8092BHering Robert A · Anchorage, AKN8092TFlying Colors Airparts Inc · Leesburg, FLN8092VRohm Arne · Miller, MON80931Augusta Aviation Inc · Augusta, GAN8093FHardy Peter Nicholas · Los Osos, CAN8093LNevins Mark B · Gresham, ORN8093TScholl Adam J · Garretson, SDN80941Holombo Ray J · Taylors, SCN8094BRutherford County Air Rescue Squad · Rutherfordton, NCN8094GTri Rotor Spray & Chemical · Ulysses, KSN8094TMapes Rocky A · Thornton, CON8094XJenkins Matthew · Bend, ORN80952Registered aircraftN80959Mets Flying Club Inc · Fairmount, INN8095BYeagley Daun E III · Moraine, OHN8095SKimball James D · Osceola, IAN8095TCarter Audie L · Port Saint Lucie, FLFirst renewal noticeN8095XBall Christopher B · Homer, AKN80961A S Air LLC · Lantana, FLN8096TSchoonover Emma L · Wichita Falls, TXN80975N80975 LLC · Wilmington, DEN8097FBlue Sky Powers LLC N8097f LLC · Dover, DEN8097LPeters Aero Plus LLC · Freeland, MIN8097XKublank Nathan S · Sun Prairie, WIN80982Reiselt Paul T F · Corinth, MSN80985Mullins James C · Franklin, TNN8098AGann Clifton T · Guthrie, OKN8098ERegistered aircraftN-number assigned, not yet registeredN8098LJordan James R Trustee · Hermon, MEN8098XRaphael Christopher M · Colorado Springs, CON80991Flowers Robert Clyde III · Manchaca, TXN80996Halley Dan R · Avery, TXN8099BKlosterman Aviation LLC · Celina, OHN8099LMateaki Koreen · Anchorage, AKN809BTLouisville Aircraft Leasing LLC · Louisville, KYN809CPCivil Air Patrol · Maxwell Afb, AL
Back to AD 79-10-14 R1