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.
N9522SSnohomish Flying Service Inc · Snohomish, WAN9522WPrio Frank A · Milwaukee, WIN95231Duncan Paul D · Norfolk, NEN95236Plane Crazy LLC · Bennington, NEN95237Klassen Glenn Kurt · Chandler, AZN95238Date Greg · Spokane Valley, WAN9523DHauser Nathan S · Newark, DEN9523HVictor James A · Kingsville, OHN9523JMichalka James R · Portage, MIN9523LCnaa LLC · Mooresville, NCN9523WOberg Harry W C III · Evanston, WYN95242Kane Aviation Holdings LLC · Bernardsville, NJN95244Banas Darryl P · Waco, TXN9524JZanella Paul J · Ballston Spa, NYN9524LHritz Michael G · Carlisle, PAN9524QHernandez Joseph P · Arvada, CON95253Mmou LLC · Fort Worth, TXN95255Herren Robert H · Lexington, KYN95259Erickson Landon S · Fairbanks, AKN9525DFlying Neutrons LLC · Lebanon, OHN9525JSandpiper Nag LLC · Louisville, KYN9525MVaughn Robert Bruce · Macon, GAN9525PGeorgetown Flying Club LLC · Pawleys Island, SCN95264Jorquez Andrew D · Santa Paula, CAN95265Red River Aviation Services LLC · Altus, OKN95266Walton Robert · Franklin Lakes, NJN9526BWildenberg Ronald · Beloit, WIN9526GAtlas Aviation Tampa Inc · Tampa, FLN9526HAbove The Haze LLC · San Lorenzo, CAN9526JWorthington Brian · Las Vegas, NVN9526LAnderson Jeffrey · Ann Arbor, MIN9526MRegistered aircraftN9526PSlenicka Kevin B · Enterprise, ALN9526WMarch Theodore M · Fernley, NVN9526YBeechcraft Heritage Museum · Tullahoma, TNN95270Get Away 1 LLC · St George, UTN95271Ederer Martin J · Baraboo, WIN9527JOklahoma Flight Academy LLC · Owasso, OKN9527WDieck Michael J · Fayetteville, NCFirst renewal noticeN95285Bangerter James Alan · Indn Hbr Bch, FLN9528DGreenhead Flight Services LLC · Bemidji, MNN9528JGiles Dennis E II · Pearson, WIN9528WWings Over Texas Holdings LLC · Denton, TXN9529DHeil Jay E · Brownton, MNN9529LMcdaniel Mark O · Martinsville, INN9529MWilson Judy · Stamps, ARN9529PCentral Air Parts Inc · Staunton, ILN9529SRegistered aircraftN9529WFlight Operations Aircraft LLC · Wilmington, DEN952AArcher Aero LLC · Wilmington, DE
Back to AD 87-10-06 R1