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.
N7671YBailey Wryan T · Nashville, TNN7672JWeiner Johannes · New Paltz, NYN7672PSantore William F · Laguna Niguel, CAN7672SLouisville Soaring Club Inc · Lexington, KYN7672WCrossroads Aviation LLC · Leesville, LAN7672YBertrand Jason · Seattle, WAN7673GSchaack Lawrence A · Woods Cross, UTN7673PR M Kraft Ag Inc · Cut Bank, MTN7673RGiles Dwight L · Greeley, CON7673WNew Horizons Aviation Inc · Goshen, INN7674CFiyalko Wayne · Fort Myers, FLN7674FCarter Rhonda L · Columbiana, ALN7674HOverly Terrence L · Tok, AKN7674JAerofeather Aviation Inc · Suffolk, VAN7674PChurches Michael D · Smyrna, TNN7674SMurtagh Johhny T · Lexington, MSN7674YBooth James R · Nevada City, CAN7675JDimmlich Scot A · Conyers, GAN7675PEhrhart Jerry L · Mount Joy, PAN7675RKline John C · Wolcottville, INN7675WAltitude Aircraft Leasing LLC · Burnet, TXN7676FNationwide Aviation LLC · Hudson Oaks, TXN7676GPalmer Michael C · Emmett, IDN7676PHanneman Robert D · Denver City, TXN7676WEsparza Vincent A · Friona, TXN7676YCoffman Robert P · Bigfork, MTN7677FWestern Robert E · Stanley, NDN7677PHenderson William C · Grafton, WVN7677RAlpha Bravo Charlie 1 Corp · Houston, TXN7677VDoxtator Christopher P · Covington, INN7677WNikolic Peter Jr · Momence, ILN7677ZSpurlock Ricky DBA · Jensen, UTFirst renewal noticeN7678DEldridge William D · Anchorage, AKN7678GTanner Michael J · Hooksett, NHN7678PMunday Jeff R · Waverly, GAN7678VHinckley David D · Belton, TXN7678WDsr-Cherokee 180 LLC · Dallas, TXN7679FScott Field Flying Club LLC · Elgin, IAN7679GShipp-Hove Kylan · Mesa, AZN7679HSummerskyz Inc · Urbana, ILN7679RSmith Melissa R · Atlanta, ILN767ACWooldridge Kent L · Albany, ORN767APHorvath Patrick L · Conyers, GAN767AWTooth & Go Flyers LLC · Farmington Hills, MIN767BRRv8r Aviation LLC · Wilmington, DEN767CDTyler Flyers Inc · Tyler, TXN767CEReviere Russell E · Jackson, TNN767CVNcv LLC · Jacksonville, FLN767DCMariah Aviation Corp · Miami, FLN767DDAckerman Garry A Jr · Plano, TX
Back to AD 87-10-06 R1