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.
N1949RClemons Pamela K · Boone, IAN19JDCline Jo Ann · Greensboro, NCN2001EZamora Loretta · Albuquerque, NMN20035Sky Adventures Inc · Oxford, MIN2007FKirby Adam R · Scotts, MIN2020FFlying Unlike Noneother Ltd · Raymond, NEN2029TGardner Thomas E · Albuquerque, NMN2031FDavis John C IV · Evergreen, CON2039HMarkowitz David B · Maryland, NYN2039TLillard Larry J · Colorado Springs, CON20441Jd Adventures LLC · Piscataway, NJN2044FWilliams Frank M · Clearwater, FLN2046HWallis Edward J · Calistoga, CAN2052SSanderson Alan R · Albany, ORN2052XCentennial Aerosports LLC · Choctaw, OKN2057FGrand Junction Balloon Port · Fruita, CON20586Richardson Sean M · Kannapolis, NCN2059BChapton Donald H Trustee · Menifee, CAN2075NPowers Daron A · Pewaukee, WIN20796Marketing Services Inc Of Pueblo DBA · Colorado Springs, CON2080CCaputo Joseph A · Pittston, MEN2081KSkylifter LLC · Naples, FLN2085EScheve Eric J · Spirit Lake, IAN2086DSuskin Dan · Atlanta, GAN2088FRogina James W · Anchorage, AKN2096HPortland Rose Balloons LLC · Wilsonville, ORN20NDarling Louann · Cleburne, TXN2103FGivler James B · Hudson, MAN2103YPage Charles T · Cleveland, NCN21046Harrison Stephen R · Murray, UTN2105MAeronautical Adventures Inc · Eagle, IDN2106FDekoevend Gery R · Fort Garland, CON2115HSale Reported · Cincinnati, OHSale reported, pending cancellationN2116GLongeill David J · Auburn, NYN2117PKenworthy Christopher M · Rio Rancho, NMN2132UGauger Aaron D · Rolesville, NCN21349Sky Adventures · Oxford, MIN21410Welz Zerek A · Albuquerque, NMN2145HO Brien Michael J · Berkley, MIN21467Sanderson Alan R · Albany, ORN21510Caldwell Clint C · Rio Rancho, NMN2156SBarnes Alfred Cavis III · Norwich, NYN2161LCastanier Susan B · Albuquerque, NMN216FSLowenstein Albert L · Albuquerque, NMN21823Lewis John R · Leakey, TXN21824Thornton Ronald · Littleton, MAN21830Bauschatz Ross A · Colonial Heights, VAN21847Allbaugh Laurie B · Waterloo, IAN2184CCline Ricky W · Hickory, NCN2184GLansdown Jeffrey L · Danridge, TN
Back to AD 75-12-08