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.
N7265WSayles Michael A · Shorewood, ILN7265ZAtp Aircraft 2 LLC · Wilmington, DEN72662Jwa Flight School LLC · Bolingbrook, ILN72664Advanced Aviation Group LLC · Frederick, MDN72667Rro Leasing LLC · Grand Forks, NDN72669Mid-Island Air Service Inc · Ronkonkoma, NYN7266BButtonwood Construction LLC · Islamorada, FLN7266DMelbourne Flight Training LLC · Melbourne, FLN7266JPaolo Keath R · Carlton, ORN7266MFerrarer Joseph H Trustee · Glendora, CAN7266NBeck Robert A · Cove, ORN7266PGrover Donald G · Canby, ORN7266QLima-001 LLC · Muscatine, IAN7266WNewland Hunter R · West Valley City, UTN7266YAvero Aviation LLC · Dover, DEN7266ZBearing Tree Land Surveying LLC · Oklahoma City, OKN72671Vfr Aircraft And Training LLC · Jackson, MON7267FRegistered aircraftN7267GWells Jack D · Newtown, MON7267JSe Aviation LLC · Boise, IDN7267TDmcc LLC · Lewes, DEN7267WGillespie Michael Lee · Jacksonville, FLN7267YVolatilis Aviation LLC · Collinsville, ILN7267ZHoffpauir Jeremy · Broussard, LAN72689Brown Nathan · Snellville, GAN7268DLarsen Daniel R · Kenai, AKN7268FFarber Gerald · Las Cruces, NMN7268GSteel & Supply Co LLC · Pensacola, FLN7268KFelts Field Flying Club · Spokane Valley, WAN7268PSurdex Corp · Chesterfield, MON7268Y612 Holdings Lp · Decatur, TXN7268ZWestwind Aviation Inc · Phoenix, AZN72692Mccurdy Dwight B · Anderson, INN7269416 Sandals LLC · Tuscaloosa, ALN72695Surdex Corp · Chesterfield, MON72696Bass Adventures LLC · Anchorage, AKN72697Cbt Aviation LLC · Bellingham, WAN7269BReece Vance · Winnsboro, TXN7269CCollins Carliss Alvin · Andrews, TXN7269FChandler Joseph · Amana, IAN7269GBranson Barry R · Shasta Lake, CAN7269KDeatley Crushing Company Inc · Lewiston, IDN7269PBoucher Bobbi · Fredericksburg, VAN7269QBaker Mark · White Bear Lake, MNN7269RSm1019 LLC · Gillette, WYN7269TAg N7269t LLC · Salt Lake City, UTN7269WButtercup Express LLC · Woodward, OKN7269XCummings Cove Air LLC · Gloucester, MAN726ACGrass Roots Aviation LLC · Bend, ORN726AJStarr Alan D · Senoia, GA
Back to AD 87-10-06 R1