AD 87-10-06 R1
Registered aircraft · 72,010
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:87-10-06-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:87-10-06-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:87-10-06-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:87-10-06-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.
N821SHAero Leasing Inc · Brookings, ORN821UMCoastal Defense Inc · Mill Hall, PAN82209Pearl Darwyn L · Bend, ORN8220PParsell Scott · Katy, TXN8220QWallentine Ranch LLC · Dover, DEN8220WSb Farms LLC · Bowling Green, OHN82213Anderson Stephen A · Yuba City, CAN8221NFedchenko Vitaliy · Cumming, GAN8221PMoreau Donald G · Dayton, TXN8221YBill Kennedy Aviation LLC · Stuart, FLN82221Hahn Dave · Brooklyn Park, MNN82225Dow Clifford G II · Falmouth, MEN82226Plane & Pilot News · Ravenna, OHN8222DPaphos Airways LLC · Farmingdale, NYN8222FJefferson City Aviation Inc · Jefferson City, MON8222HBartek Matthew S · Wylie, TXN8222JShvetsov Vitaly S · La Canada Flintrid, CAN8222PWeirich Joseph J · South Milwaukee, WIN8222WMitzel Aaron · China Spring, TXN8222YMorale Line Aviation LLC · Albuquerque, NMN82236Ingle Nicholas A · Cora, WYN822397 Dolors LLC · Urbana, OHN8223CCurless Timothy A · Demotte, INN8223NEvans Jay M · Arrington, TNN8223TTrident Aircraft Leasing LLC · Easton, MDN82241Naranjo Navarro Jose N · Las Vegas, NVN8224KPelayes Tristan · Temecula, CAN8224NDc Aviation LLC · Appleton, WIN8224WDavis William M · Chattanooga, TNN8224YWoodard Earl G Jr · Danville, GAN82253Dirt Strip Dirtbags LLC · Whitefish, MTN82255Quinn John J III · Merritt Island, FLN82259Pedersen Eric D · Mccall, IDN8225AFast Track Aircraft LLC · Oxford, MSN8225PTenntech Corp · Wilmington, DEN8225RNorris Craig A · San Carlos, CAN8225UNagy John F · Whittier, CAN8225VRunge Thomas A · Sterling, VAN8225WLewis Devin H · Lacey, NJN8225XWarren Dennis J · Denver City, TXN8226HForward Jeffrey C · Oakes, NDN8226VParchman Travis R · Philadelphia, PAN8226YC P L Air LLC · Middletown, DEN82274Harris James M · Bemidji, MNN82279Boyce Peter C · New Albany, INN8227NRegistration Pending · Dawsonville, GARegistration pendingN8227WQuarter Circle E Enterprises Inc · Yorba Linda, CAN82285Horton Charles M · Wilkeson, WAN8228ASlater Charles · Delafield, WIN8228WKoaks Aviation LLC · Farmers Branch, TX
Back to AD 87-10-06 R1