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.
N682RByrd Cattle Co Inc · Canyon, TXN682SBSundowners Inc · Fort Myers, FLN682TFAir Fleet Holdings LLC · Addison, TXN682TXHartman Joshua Albert · Andover, KSN6830EJackson Thomas M · Florissant, MON6830PGregory M Gabriela · Las Vegas, NVN6830UJilek Dominic A · River Falls, WIN6831HQuarry Jon C · Memphis, TNN6831VMirage Partners LLC · Biddle, MTN6832FJpf Ventures LLC · Owatonna, MNN6832JHolseberg Properties LLC · Ridgeville, SCN6832PDrag Walter J · Longs, SCN6832ULanetti Leonard J · Malvern, PAN6832VCrawford Sharri R · Rio Rancho, NMN6832WLitchfield Bobby Lee · Claremont, CAN6833BBlatchford Devin M · Arkansas City, KSN6833CTexins Flying Club · Mckinney, TXN6833FPatriot Aviation LLC · Huntington, INN6833JHumphries Aviation LLC · Maysville, KYN6833PHolmes Darrell · Chino Hills, CAN6834NSiebold David J · Painesville, OHN6834UFlydog Aviation LLC · East Grand Forks, MNN6834VDavis James D · Hamilton, MTFirst renewal noticeN6834WFlores Lindenfelser Armando · Apache Junction, AZN6835HIowa Lakes Community College · Estherville, IAN6835JPronk Glen R · Crittenden, KYN6835NHirzel William J · Walbridge, OHN6835PMarvin Shawn · Tomahawk, WIN6835UBas Part Sales LLC · Greeley, CON6836BHowes Christopher T · Allardt, TNN6836UEllis Grover D · Sanford, NCN6836VHonaker Ronald R · Saint Louis, MON6836YOld School Aircraft LLC · Jackson, TNN6837KHagglund Carl D · Pendleton, ORN6837NBloom Alexsandr · Westfield, MAN6837UJohnson Aviation LLC · West Lafayette, INN6838BMize Donnie Glenn · Pearland, TXN6838PHartley Victor A III · Woodbine, NJN6838UPethe Travis K · Littleton, CON6839PFriesen Brad A · Plains, TXN6839UEgbert Ryke Scott · Ogden, UTN683ATTexas Flight Training Aircraft 8 LLC · Wilmington, DEN683FLPuhalla Matthew C · Shelton, NEN683JAYale Companies LLC DBA · Indianapolis, INN683LHChristiansen Aviation LLC · Wilmington, DEN683RUniversity Of North Dakota · Grand Forks, NDN683RLMach 10 Cap LLC · Fincastle, VAN683SHSouthern Utah University · Cedar City, UTN683SPNovember 243 Bravo Mike LLC · Castle Rock, CON6840JBeineke Paul · Marion, OH
Back to AD 87-10-06 R1