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.
N65742Mustang Sally Aviation LLC · Camden, SCN65743University Of Central Missouri · Warrensburg, MON65746Son Cameron D · Groveland, FLFirst renewal noticeN6574DFly Carolina LLC · Concord, NCN6574GPplforu LLC · Fort Worth, TXN65750Christiansen Aviation LLC · Wilmington, DEN65752Owens Flight Training LLC · Lafayette, LAN65753Flying Bulldogs LLC · Joplin, MON65756Brown Justin M · Peachtree City, GAN65758American Patrols Inc · Midland, TXN6575EPoutre Robert P · Osceola, WIN6575PTrade Winds Aviation Holdings LLC · Lewes, DEN6575VGreeson Albert O · Moscow, KSN6575WStrouse Joshua L · Columbia, MON65767Chu'S Sky LLC · Brandon, FLN6576BMoore Roger W · Poinciana, FLN6576JPa28 Nevada LLC · Incline Village, NVN65770Thompson Clinton J · Greer, SCN65772Sky Adventure LLC · Bartlett, TNN65773Ial Corp · Lewes, DEN65775Ristrim Eric · Henderson, NVN65776Meridian Aviation Holding Company · Teterboro, NJN6577HRegistered aircraftN6577JSpark Solar Power LLC · Chandler, AZN6577RAir Echo Alpha 51 LLC · Erie, CON6577UKoehler Richard E · Port Orange, FLN6577WAdventist World Aviation · Wilson, NCFirst renewal noticeN65784Ohio State University · Columbus, OHN65789Burket George C · North Hollywood, CAN6578AAir Mods And Repair Inc · Robbinsville, NJN6578JMalone W Paul · Coulee City, WAN6578RGrinnell Herbert W · Oroville, CAN6578UJbl Aeronovia LLC · Kent, WAN6578VPence Dale E · Richmond, MON6578WHanauer Keith A · Bloomfield, INN65794Baker Curtiss L · Kinston, NCN65798Samons David M · Phoenix, AZN6579JBender Auto Body Inc · Middleville, MIN6579PDantas Ricardo J · Apple Valley, CAN6579URegistered aircraftN6579YTaco Tyme LLC · Hobe Sound, FLN657CAOlson David A · New Underwood, SDN657CPCivil Air Patrol · Maxwell Afb, ALN657MJRumiano Keith D · Vina, CAN657NDUniversity Of North Dakota · Grand Forks, NDN657RVHart Tom J · Aurora, ORN657SPChristiansen Aviation LLC · Wilmington, DEN657SRRm & Lp Ltd · Azalea, ORN657TBWilson Adrian H · Orange Park, FLN65805Wilkerson William E · Crewe, VA
Back to AD 87-10-06 R1