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.
N73PPArew Aviation LLC · San Tan Valley, AZN73PWWarren John M · El Paso, TXN73RTRegent Trust Corp Trustee · Wichita, KSN73RWSeppala Joel H · Taylors, SCN73RZBas Part Sales LLC · Greeley, CON73SSchulze Craig W · Burbank, CAN73SDMedlock-Turek Patick Evan · Clifton, NJN73SHEaton Michael J · Killen, ALN73STClearskys Aero LLC · Seneca, SCN73TDWeber Michael Scott · Gonzales, LAN73TLTeaff Leslie T Trustee · Russellville, ARN73TSWeene Michael L · Moultonborough, NHN73VPyle Dana · Naples, FLN73WGGlattli William H · Boynton Beach, FLN73WHBumble Bee Aviation LLC · Brookfield, WIN73WRStanton Fred H · Amherst, NYN73ZFlying Rocks LLC · Sparkill, NYFirst renewal noticeN7400DSmith Dwight S · Ann Arbor, MIN7400RHambey Eric M · Walnut Grove, MON7400SHutter Charles G · Carson City, NVN7400YWright Amos L Jr · Enterprise, ALN74024Milner Stephen L · Dallas, TXN74026Coburn William E · Carrollton, VAN74027Harvey James R · Ocala, FLN7402RReynolds Gary W · Forest, VAFirst renewal noticeN7402VKendrick Brian S · Kerrville, TXN7402YN5746u LLC · Dover, DEN7403JMejia Ramirez Martin E · Perth Amboy, NJN7403PElliston Charles R · Brighton, CON7404PWhisler Greg A · Lincoln, NEN7404RT&G Aviation Services LLC · Temple, TXN7404YSlowpoke Air LLC · Palm Harbor, FLN74051Plane Fun LLC · Valdosta, GAN74052Macdonald Mark A · Muskego, WIN74057Madden Patrick · Fort Lauderdale, FLN74058Ricci Anthony Albert · Bishop, GAN7405GStan And Amy Weyer Aircraft LLC · Punta Gorda, FLN7405JMills Bailey J · Salem, ALN7405PClassic World Holdings LLC · Wilmington, DEN7405VBarrett Ronald A Jr · Shreveport, LAN7405WGo Fly Az LLC · Gilbert, AZN7405XWills Terry W · Cedar Park, TXN7406PAviation Collective LLC · Fort Worth, TXN7406VEvans Steven M · Somis, CAN7406YTucker Engineering Associates Inc · Locust, NCN74079Marques David A · Gilbert, AZN7407FFp Aircraft Holdings LLC · Alvord, TXN7407WTevik Michael A · Provo, UTN74080Lowry John O · Willis, TXN74086Meyer Michael · San Diego, CAFirst renewal notice
Back to AD 87-10-06 R1