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.
N6416JGallant Kenneth R · Beach Haven, NJN6416RNational Aviation Academy Of Mississippi Inc · Clearwater, FLN6416USt Marie Jack W · Encinitas, CAN6416YMcm Aviation LLC · Estero, FLN64173Training Planes LLC · Tampa, FLN64174Sen Air Inc · Mckeesport, PAN6417JChapman Michael K · North Salt Lake, UTN6417RBogey Aviation LLC · Piqua, OHN64180Spanaflight LLC · Puyallup, WAN64181Christiansen Aviation LLC · Wilmington, DEN64184Arlington Flight Services Inc · Arlington, WAN64186Paraloft LLC · Mims, FLN6418DAirways Aviation Inc · Grand Rapids, MNN6418ELima-001 LLC · Muscatine, IAN6418YWalker Gilbert R · Brentwood, TNN64191Flycarolina LLC · Concord, NCN64192Skyhawk Transport LLC · Hazel Green, ALN64198Randy Goering Inc · Bend, ORN64199Mutschler George Robert Jr · Bayfield, CON6419JMathis Charles D · Carrollton, GAN6419PHelisur USA LLC · Pembroke Pines, FLN6419QFranklin Brian K · Lakewood Ranch, FLN6419VUrbana Aircraft LLC · Urbana, MDN641BStoddard Robert James · Brush Prairie, WAN641BBJones Legal Holdings LLC · Pikeville, KYN641CBBrownd Carl L · Tucson, AZN641CCClub Cherokee Inc · Crystal, MNN641DHFisher Russell D · Vacaville, CAN641FTFlorida Institute Of Technology · Melbourne, FLN641GWSnyder Jerry W · Greybull, WYN641JMDubose Mack H · Edmonds, WAN641MAAscent Aviation Inc · Duluth, MNN641PPhilip Mark A · Leesburg, VAN641PSSmith Michael J · Napa, CAN641PTPapa Tango LLC · West Monroe, LAN641RHJakes Guide Service LLC · Willow, AKN641RVDavies Chris D · Caddo Mills, TXN641SManning Robert S · Rosamond, CAN641SPRhode Island Air LLC · Providence, RIN64201Registration Pending · Lander, WYRegistration pendingN64203Vance Nicholas D · Bluffton, OHN64209Kay Roland C · Wasilla, AKN6420JPomerenke Tyler J · Fairmont, MNN6420QKelley Richard E · Spring Branch, TXN6420ULambert Glen C · Las Vegas, NVN6420VKorson James · Yorkville, ILN64213Ajc Aviation LLC · Boca Raton, FLN64215Registered aircraftN64217Simplifly LLC · Mesa, AZN64219American Patrols Inc · Midland, TX
Back to AD 87-10-06 R1