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.
N6461PSullenger Charles H · Statesboro, GAN6461QGanos Christ · Brookfield, WIN6461RBetsy N6461r LLC · Novato, CAN6461VRegistered aircraftN6461WOverstreet Aviation LLC · Sunray, TXN6462CA&J Aircraft Leasing Inc · Burlington, CON6462DN2893e LLC · Reno, NVN6462JRentz Bradford C · Baxley, GAN6462QPlummer Joshua · Fort Mill, SCN6462RGoodens Floorcovering Inc · Tallapoosa, GAN6462UAnderton Roy · Colbert, OKN6462VVanbergen Shaun S · Ashland City, TNN6462WBauer Richard M · Greensboro, NCN6462ZMinden Soaring Club Inc · Minden, NVN6463GTeens-In-Flight Inc · Palm Coast, FLN6463JSorenson Mark A · Senoia, GAN6463UVip Leasing LLC · Mesa, AZN6464DHoney B LLC · Hillsboro, ORN6464MMajorek Miroslaw · Mountain View, CAN6464RChristiansen Aviation LLC · Wilmington, DEN6464USherman Stanley Robert · Altus, OKN6464WTechnical Educational Services Inc T/A · Virginia Beach, VAN6464ZFlying Tiger LLC · Birmingham, ALN64655Dave'S Aircraft Inc · Edgewater, FLN6465JAardvark Aviation Inc · Greentown, INN6465PKesser Gilbert M · Culpeper, VAN6465QLeckrone Steven R Trustee · Mustang, OKN6465THurricane Corp · New York, NYN64664Szpak Michael W · Albany, GAN6466CConey Island Lunch LLC · Erie, PAN6466DValley River Leasing Inc · Murphy, NCN6466JHomesick Angel Aircraft Management · Grove, OKN6466QSherrod Paul A Jr · Opelika, ALN64674Vaughan Stephen D · Finchville, KYN64678Ocean Aviation Inc · Berlin, MDN6467CSugden William H · Alexandria, MNN6467JAircraft Guaranty Corp Trustee · Oklahoma City, OKN6467RKightlinger Kenny L Jr · Murfreesboro, TNN6467WStichnoth Marvin L · Bourbonnais, ILN64686Kadena Aero Club · Apo, APN6468DShorter Laurence K · Hinsdale, MAN6468FFlying Aces Aero Fleet Inc · Guyton, GAN6468JTxfliers Aviation LLC · Corpus Christi, TXN6468PTevis Aviation Enterprises LLC · Newcastle, OKN6468RMargolis Brian M · Florence, MAN6468ULi Yoi Y · Largo, FLN6469JDouble Eagle Flyers LLC · Albuquerque, NMN6469QBurl Jeffrey B · Hancock, MIN6469RBaboul Anwar G · Carmel, INN6469USoares Marcus K · Boca Raton, FL
Back to AD 87-10-06 R1