AD 75-12-08
Registered aircraft · 949
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:75-12-08')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:75-12-08')
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:75-12-08') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:75-12-08') 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.
N1524VHooper Kirk M · Albuquerque, NMN1525GWagner Cameron B · Casper, WYN1525LStar Ballooning LLC · Bridgewater, VAN1525REmerald Shazam Inc · Pittsburgh, PAN1525XSutter Denis M · Hallsville, MON1525YAeronautical Adventures Inc · Eagle, IDN1526LKolb David B · Monticello, ILN1526RGallant Michael T · Columbus, INN1526UPayne Ralph J · Hastings, MIN1526YSeeger Kenneth Anthony · Travelers Rest, SCN1526ZHannigan Jerome W · Mounument, CON1527EDunavent Duncan · Statesville, NCN1527JSale Reported · Rochester, NYSale reportedN1527LReich Edwin B · Meridian, IDN1527QSewell Robert M · Reno, NVN1527SKuschel C David · Maryville, ILN1527TJackson Dwayne K · Rio Rancho, NMN1527UHill Michael E · Conifer, CON1527ZPierre Peter A · Fresno, CAN15281Hot Air Enterprises Lc · Payson, UTN1528MChilds Cary J · Wellsville, NYN1528UReinert Michael P · Alta, IAN1528ZNext Generation · Roswell, NMN1529GGrandinetti Robert L · Fayetteville, NYN15332Forney Gary R · Ennis, MTN1533FMcgrath John H III · Cary, ILN1533GAlbertson James M · Westville, FLN1538ABruce Bailey L H · Raleigh, NCN1543ENelson Gregory C · Minden, NVN1544UBouton Vern H · Fairbanks, AKN1544YTannehill Theodore J · Howard, OHN155DWLafountain Donald A · Florence, MAN1595MUniversity Of Central Missouri · Warrensburg, MON1606FOld World Ballonery LLC · Overland Park, KSN1620CChemello Dominic · Prescott, AZN1622LFaust Robert H · Glendora, CAN1624LBlackburn Jonathan C · Cottonwood Heights, UTN1639LKell Rodger G · Phillipsburg, NJN1640LSmith Roy H · Moody, ALN1642LDekoevend Gery R · Fort Garland, CON16442Rainwater Anthony · Knoxville, TNN1644LNew Market Aeronautics LLC · Round Hill, VAN16455Arrington Vineyards LLC · Arrington, TNN1645LBaron Brenda · Albuquerque, NMN1646LKent Karen S · Port Allen, LAN1647AMarketing Services Inc Of Pueblo · Colorado Springs, CON1647JRistaino Damien · Monroe, NCN167CCCloud 9 Enterprises Inc · Rochester, MNN1913GPayne Ralph J · Hastings, MIN192HHHager John L · Crestview, FL
Back to AD 75-12-08