AD 90-04-06 R1
Registered aircraft · 68,377
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:90-04-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:90-04-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:90-04-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:90-04-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.
N6832PDrag Walter J · Longs, SCN6832ULanetti Leonard J · Malvern, PAN6832VCrawford Sharri R · Rio Rancho, NMN6832WLitchfield Bobby Lee · Claremont, CAN68332Wings Over Texas Holdings LLC · Denton, TXN68334University Of Michigan Flyers · Ann Arbor, MIN6833BBlatchford Devin M · Arkansas City, KSN6833CTexins Flying Club · Mckinney, TXN6833FPatriot Aviation LLC · Huntington, INN6833JHumphries Aviation LLC · Maysville, KYN68342M & S Air Supply Inc DBA · Hawthorne, CAN68344South Bay International Flight Association Inc · Torrance, CAN68348Tully Robert · Eighty Four, PAN68349East Derrick A · Cullman, ALN6834KKilbourned Garrot · Liberal, KSN6834NSiebold David J · Painesville, OHN6834UFlydog Aviation LLC · East Grand Forks, MNN6834VDavis James D · Hamilton, MTFirst renewal noticeN6834WFlores Lindenfelser Armando · Apache Junction, AZN68356Don Davis Aviation Inc · Henderson, KYN6835HIowa Lakes Community College · Estherville, IAN6835JPronk Glen R · Crittenden, KYN6835KWill Robert I Jr · Shoreline, WAN6835NHirzel William J · Walbridge, OHN6835UBas Part Sales LLC · Greeley, CON6836BHowes Christopher T · Allardt, TNN6836KBundrant Wlliam D · Snellville, GAN6836UEllis Grover D · Sanford, NCN6836VHonaker Ronald R · Saint Louis, MON6837KHagglund Carl D · Pendleton, ORN6837NBloom Alexsandr · Westfield, MAN6837UJohnson Aviation LLC · West Lafayette, INN6838BMize Donnie Glenn · Pearland, TXN6838UPethe Travis K · Littleton, CON6839UEgbert Ryke Scott · Ogden, UTN683ATTexas Flight Training Aircraft 8 LLC · Wilmington, DEN683FLPuhalla Matthew C · Shelton, NEN683JAYale Companies LLC DBA · Indianapolis, INN683LHChristiansen Aviation LLC · Wilmington, DEN683SHSouthern Utah University · Cedar City, UTN683SPNovember 243 Bravo Mike LLC · Castle Rock, CON68402Space Coast Aircraft Co · Merritt Island, FLN6840KValley Airways Inc · Scottsbluff, NEN6840NJohnston Robert M · Plantation, FLN68414Wright Duane C · Sanford, FLN68418Moore Michael P · Houston, TXN6841LSaglimbene Ronald · Wyckoff, NJN6841MGwiazdon Edward P · Lake Elmo, MNN6841WBoehm Darrell · Safford, AZN68423Aughenbaugh Alan M · Iroquois, SD
Back to AD 90-04-06 R1