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.
N777DPArnold Vincent Craig · Rosharon, TXN777DTMcchristian Jerome M · Granbury, TXN777DUSc Infinities LLC · Dover, DEN777DVTharp Thomas J · Nampa, IDN777DWLawless Aviation LLC · Fishers, INN777EEDga Aviation LLC · Sacramento, CAN777ESD&J Aviation LLC · Gotha, FLN777EZInternational Aviation Group LLC · Lake Wales, FLN777FJStewart Michael W · Snellville, GAN777FMBolduc John A · Port Saint Lucie, FLN777FSCasey William F · Ponderay, IDN777GC777gc Holdings LLC · Milford, CTN777GEAir Float One LLC · Stuart, FLN777HZCb Auto Inc · Columbia, MDN777JRMiloud Chadd K · Fort Worth, TXN777JYKingslyn Ltd · Wilmington, DEN777KBGeisler Stephanie N · Inman, SCN777KGLonnevik Dennis F · Bigfork, MTN777KPKelly'S Flying Service LLC · Warrensburg, MON777LCSelover Stephan Holger A · Lake Oswego, ORN777LFAeolian Corp · Wilmington, DEN777LH7 Moon LLC · Albuquerque, NMN777LTYates Deborah L · Pioneer, CAN777LYUmpqua Flying Organization LLC · Roseburg, ORN777MEDe La Garza De La Fuente Jose A · Montgomery, TXN777MKPecori Emil R · Oakdale, PAN777PWAerowest LLC · Independence, ORN777PYMark Britain Productions LLC · Amarillo, TXN777RHLarson Peter T Trustee · Coraopolis, PAN777RLLandau Management Services Inc · Toranga, CAN777RZRapid 6 Flyers LLC · Rapid City, SDN777SNichols Max E · Great Bend, KSN777SCInternational Air Services Inc Trustee · Carson City, NVN777SDBoomerang Air LLC · Cedar Park, TXN777SKDj Internet Commerce LLC · Crowley, LAN777SRWilkie David J · Nashua, NHN777SWRegistered aircraftN777SXSkinner Norman D · Osceola, IAN777TRBlack Vernon N · Hildale, UTN777UHRobinson Helicopter Company Inc · Torrance, CAN777VAVolante Aircraft LLC · South Jordan, UTN777VCChaney Van G · Niceville, FLN777VJTucker Billy J · Arley, ALN777VLFirst Aerial Assault Inc · Williamston, NCN777VPFlightwing Equipment Corp · Beverly Hills, CAN777VXGutierrez Ruben E · Fontana, CAN777VZFreeman Brooks · Richmond, VAN777WLucky Shot LLC · Dayton, OHN777WBClark Lloyd E · Hanover, MDN777WJMorrison Mark W · Bloomingdale, IL
Back to AD 87-10-06 R1