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.
N21850Oberman Michael W · Queen City, MON21854Steenhoek Jessica · Pella, IAN2185ZShore Nathan · Rio Rancho, NMN21865Parton Jennifer A · Macedon, NYN21868Simon Eric · Montrose, CON2186HWilkinson Steve A · Lake Havasu City, AZN2186WSeki Shiho DBA · Temecula, CAN21872Mccall Freddie W · Brewton, ALN2187WWhitford L Chandler · Wellsville, NYN2187YA Beautiful Balloon LLC · Parsippany, NJN2188FSchneider Scott D · Goddard, KSN2189HHolmes Jerry L · Fort Worth, TXN2189SSena Paul A · Worthington, MAN2189XMarkowitz David B · Maryland, NYN21906Coffing Mark A · Knoxville, TNN21907Markowitz David · Maryland, NYN2191GGreen Robert H · Escondido, CAN21926Pedersen Tyler · Johnston, IAN2192SBig Sky Hot Air Ballooning Inc · Oxford, MIN2192UWeaver David B · Boulder, CON21935Leisek John C · Tooele, UTFirst renewal noticeN2193ABarnhill Jayson D · Longview, TXN2193DUp Away Inc · Churchville, PAN2193ZTsb Solutions LLC · Lebanon, INN21941Suskin Dan · Atlanta, GAN2194NNilz Raymond P · Tucson, AZN2194XPyramid Pool LLC · Glendale, AZN2194ZWolters James A · Holts Summit, MON21953Snead David W · Mechanicsville, VAN21961Tim Mcconnell Photography · Indianola, IAN21969Patterson Todd M · Clive, IAN2197JHooper Kirk M · Albuquerque, NMN2197RManning Dawn L · Spring Creek, NVN2198WWolniak Bruce · Auburn, NYN2199SSaul Daniel K · Medina, OHN2200LAerial Balloon Advertising LLC · Lake Orion, MIN2200MBuckles Kyle · Williamson, NYN2201JSkach Bruce · Wichita, KSN2202CCarr Larry Dean · Columbiana, ALN2203BGoodnow Connie R · Topeka, KSN2203QGower Marshall L · Town Creek, ALN22041Cameron The Pilot LLC · Casper, WYN22054Wilczynski John J · Lake Village, INN2205BMeyer Mark A · Vass, NCN2205QStevens Brody C · Hammond, LAN2205ZPrestige Pilot Services LLC · El Paso, TXN2206FHebda Michael J · Tigard, ORN2206PRegistration Pending · Williamsburg, OHRegistration pendingN2208FWaltman Carolyn D · Windsor, CON2210GCoffing Mark A · Knoxville, TN
Back to AD 75-12-08