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.
N722MCClassic Banjo LLC · Richmond, KYN722MGMiller David B · Elbert, CON722MWRegistered aircraftN722NDUnd Aerospace Foundation · Grand Forks, NDN722PGFuller Jon A · Goliad, TXN722RReady Aim Flyer LLC · New Castle, DEN722RATotal Prf LLC · Lewes, DEN722RMFisher Mark A · Leola, PAN722SBWoodward James W · Sagle, IDN722SDGrove Bob · Boerne, TXN722SSWind Wizards Inc · El Paso, TXN722TIowa Aviation Heritage Museum · Ankeny, IAN722TBRettig Air LLC · Riverside, CAN722TCSchmitz William C · Charleston, SCN722TTNext Gen Aviation LLC · Jenks, OKN722WWeber Robert J · Manhattan, KSN722WMPegasus Enterprises LLC · Granbury, TXN722X6 7 Holding LLC · Kalispell, MTN7230FBenautics LLC · Wexford, PAN7230GMaples Kevin T · Pueblo, CON7230JBrewer Michael S · New Haven, WVN7230LLee Patrick G · Shawnee, KSN7230PFranks Orlan H III · Belton, TXN7230QArcade Flying Club Inc · El Dorado Hills, CAN7230YVyas Shiven P · Chino Hills, CAN7231JMcflight Aviation LLC · Highland, UTN7231QDsr-Cherokee 180 LLC · Dallas, TXN7232CVector Aviation LLC · Mentor, OHN7232JEllero John L · Sun City, CAN7232POntiveros Vicente III · New Braunfels, TXN7232VSky Sailing Inc · Warner Springs, CAN7232WAwmr LLC · Conroe, TXN7233JPinnick Andrew · Beckley, WVN7233YPacific North Air LLC · Portland, ORN7234CConfidential LLC · Lutz, FLN7234FBrinker Joe E · Little Hocking, OHN7234GBittenbender Peter E · Grand Rapids, MNFirst renewal noticeN7234PEagle Ag Services LLC · Lees Summit, MON7234QLavinio Stephen E · Southampton, NYN7234VMorten Jesse L · Larimore, NDN7234WMoco Aviation LLC · Moultonborough, NHN7235Hale Edward S Jr · Brawley, CAN7235AValiair Limited Co Trustee · Casper, WYN7235GMcnair William H · Gold Beach, ORN7235WMorris George · Redlands, CAN7236DGo North Productions LLC · Glennallen, AKN7236FRegistered aircraftN7236JBackman Randy L · Bellingham, WAN7236KSchwend Brian · Forsyth, MTN7236MWright Steven William · Bend, ORFirst renewal notice
Back to AD 87-10-06 R1