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.
N914CCJ&W Racing And Aviation LLC · Port Saint Lucie, FLN914DSaker Air LLC · Charlotte, NCN914DPGonzalez Ramiro · Lancaster, OHN914ETrettin Anthony K · Mason City, IAN914GPRoy Dino · Saginaw, TXN914HMeadows Mark A · Mooresville, INN914HMMiesler Hans U · Penrose, CON914HPBonsey James E · Newberg, ORN914JBSwartz Eric C Trustee · Aptos, CAN914JDAis Wings LLC · Grand Rapids, MIN914JWWright John T · Jacksonville, FLN914LALindbergh Aviation Inc · Hampton, NHN914MGHolman Larry E · Cleveland, GAN914NCCarter Aviation LLC · Tucson, AZN914PLand-O-Lakes Flying Club Inc · Bloomfield Hills, MIN914PACoco Aircraft Inc · Merritt Island, FLN914RFHbe Aviation LLC · Salem, VAN914RLNichols Charles C · Hanford, CAN914RRMartinez Jeff L · Lewistown, MTN914SCole Thomas Ed · White Settlement, TXN914SWSilver Express Co DBA · Miami, FLN914THanley Stuart · Hollywood, FLN914TCSpeed Racer LLC · Port Orange, FLN914ZSkylens LLC · Hammond, LAN91507Eagle Aviation LLC · Spearfish, SDN9150DFitzgerald Larry · Fairbanks, AKN9150GCampbell Ken · Lincoln, CAN9150HN9150h LLC · Charleston, SCN9150VUrness John · Oakland, CAN9150WMcmullin Chad D · Roosevelt, UTN9150YTyler Transport LLC · Troy, ALN9150ZV T Whitlock Inc · Lake City, SCN91516Johnsoon Miller · Huntsville, ALN91518Hatfield Timothy E · Parowan, UTN9151HFirst Flight Corp · San Diego, CAN9151LCerrato Michael J · Dublin, OHN9151NPlane Nonsense Inc · Middletown, DEN9151VNeret Michael G · Sugarland, TXN9151XHawkins Aviation LLC · Gilbertsville, KYN9151YRegistration Pending · South Jordan, UTRegistration pendingN9152KHangar 9 Inc · Aberdeen, SDN9152SHomer Mark · Grosse Ile, MIN9152WTeal Water Investments LLC · Blanco, TXN9153CPax Enterprises Inc · Allen, TXN9153HSambriski Michael Daniel III · Long Beach, NYN9153JRamer Kristina · Ruskin, FLN9153PA&E Aviation LLC · Ruston, LAN9153SB Squared Inc · Bedford, NHN9153VRegistered aircraftN9153YAkn Inc · Crystal, MN
Back to AD 87-10-06 R1