AD 2007-04-19 R1
Registered aircraft · 108,434
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:2007-04-19-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:2007-04-19-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:2007-04-19-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:2007-04-19-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.
N5154AA&J Air Sales Inc · San Antonio, TXN5154DCivil Air Patrol Inc · Maxwell Afb, ALN5154LDunster Edward L · Traverse City, MIN5154MTx Waste Ventures LLC · Caddo Mills, TXN5154PPerry Billy C · Newburgh, INN5154QDemio Douglas · Westbrook, CTN5154RKakkar Sunit · Buena Park, CAN5154SKetler Adam · Grove City, PAN5154TCatalpa Lane Aviation LLC · Raymond, OHN5154WFreedom 5.1 Aviation LLC · Destrehan, LAN5154XTevlin Neal L · Valley, WAN5155Valiair L C Trustee · Casper, WYN5155DPritt Joseph H · Wasilla, AKN5155KSuno LLC · Calhan, CON5155LRe Aviaiton LLC · Covington, LAN5155MGreenbirds LLC · Apopka, FLN5155SSunrise Aviation Y2n LLC · Albert Lea, MNN5155TWilkes Marcus W · Simmesport, LAFirst renewal noticeN5155UFlying Unicorn LLC · Aurora, ILN5155WRegistration Pending · Northfield, NHRegistration pendingN5155XMassey Karl E L · Monterey, CAN5156ESchwankl Michael James · Wasilla, AKN5156JWings Over La Aviation LLC · West Hills, CAN5156QN5156q Inc · Elmhurst, ILFirst renewal noticeN5156RKookaburra Kiwi LLC · Post Falls, IDN5156SKnopf Kenneth E · Charleston, WVN5156WJohnson James E · Hammond, LAN5156XHorton Kelly · Hollis, OKN5156YCaprock Spraying Inc · Vega, TXN51572Registered aircraftN5157DPari Gabe M · Ontario, CAN5157KWifa (Washington International Flight Academy) LLC · Gaithersburg, MDN5157NAms Aviation LLC · South Bend, INN5157SRegistration Pending · Anchorage, AKRegistration pendingN5157YChristine Flight Inc · Denver, CON5157ZAspire Aviation LLC · Farmingdale, NYN51580Middletown Regional Flight Training Institute LLC · Middletown, OHN51582Flight School Of Gwinnett Inc · Lawrenceville, GAFirst renewal noticeN5158EHuettl Austin · Liberty Hill, TXN5158HWestern Antique Aeroplane & Automobile Museum · Hood River, ORN5158JTfs Air LLC · Loveland, CON5158LMichael J Baker · Clearwater, FLN5158MLenox Jeffrey D · Livingston, TXN5158QAnglin Cheryl · Jackson, MSN5158RBrandenburg Idu LLC · Brenham, TXN5158WMoniz Benjamin James · Brooklyn, NYN5158XSchnell Troy A · Alliance, NEN51594Candace A Larned Enterprises Inc · Long Beach, CAN51598Morgan Christopher D · Ogden, UTN5159ADavis Nicholas R · Madera, CA
Back to AD 2007-04-19 R1