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.
N8845FDowning Darrell W · Drakesville, IAN8845JWilliams Daniel · Wallingford, KYN88465Castleberry Inc · Ekalaka, MTN88467Atwood Christopher M · Brownsburg, INN8846JFighter Pilot Enterprises LLC · Eaton, CON8846LN8846l LLC · Homestead, FLN8846NDegener William L · Leonard, TXN8846PLecrone Gregory S · Granbury, TXN8846WMosby Eric M · Tallahassee, FLN88473A C E Aviation Inc · Ashton, IDN88476Bmg Aviation Inc · Bloomington, INN88477Holland William T III · Midway, ARN8847CBlumenberg Donald D · Fulton, SDN8847FNeitzer Robert W · Milwaukee, WIN8847JFlw LLC · Sandpoint, IDN8847MTravel Air LLC · Chico, CAN8847NMcdougal Thomas K · Woodward, OKN8847PSouth Texas Weather Modification Association · Pleasanton, TXN8847WCitro Michael A · Oakley, CAN8848JMegaw George C · Fort Lauderdale, FLN8848LSoaring Society Of Dayton Inc · Waynesville, OHN8848NPro Tech Aviation LLC · Corona, CAN8848PLazar Stephen D · Toledo, OHN8848WHocken David L · Avoca, IAN8848YBrunot Frank A · Spring Hill, FLN88497Airspace Aerial Media LLC · Saint Louis, MON8849JBailey Aviation Company LLC · Little Rock, ARN8849MGuertin Jim B DBA · Lincoln, CAN8849NCafran Lloyd V · Youngsville, NCN8849PCare Management Oregon Inc · New Plymouth, IDN8849WAtchison Walter L · Los Alamos, NMN884CAColeman Aero Club · Apo AeN884CCRegistered aircraftN884DCTanner Greg L · Bend, ORN884FTFlorida Institute Of Technology · Melbourne, FLN884JSCrane John R · Niceville, FLN884MManning Michael · Bakersfield, CAN884PSSpainhower Paul Allex · Taylorsville, UTN884RVDannebrock Paul W · Lockport, NYN884SADamico Frank J · Pittsburgh, PAN8850NGregs Airplane Rental LLC · Eloy, AZN8850PSharp Alan D · Dallas, TXN8851JMoore Jeffrey A · Lawrenceburg, TNN8851NBloodworth Nathan B · Hendersonville, TNN8851PRegistered aircraftN8852CWobken Mark E · Orange, CAN8852WSussex Aero Maintenance Inc · Georgetown, DEN8852YWikle Luther M · Laceys Spring, ALN8853CEuropa Aero LLC · Bucyrus, OHN8853DSlaughter Don Wayne · Farmville, NC
Back to AD 87-10-06 R1