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.
N771MBMathis Alan L · Moultrie, GAN771MKHemberger Andrew J · Troy, ILN771MMTaildragger LLC · Lakeside, ORN771MRSmith Nathan · Palmer, AKN771NDUniversity Of North Dakota · Grand Forks, NDN771PTPilot Training Center LLC · Miami, FLN771RANational Aviation Academy Of Mississippi Inc · Clearwater, FLN771RCReynolds Ronald · Ammon, IDN771SHHillsboro Aero Academy LLC · Hillsboro, ORN771VYGarcia Pedro · Hudson, OHN771WKalmar Istvan · Keller, TXN771WSCampbell Reginald G · Hilo, HIN7720DBarnhill Jerry D · Longville, LAN7720GZulu Jets LLC · Boerne, TXN7720WLagrange LLC · East Helena, MTN7720YEastern Kentucky University · Richmond, KYN7721BHill Jack D · Tulsa, OKN7721DRenick Tyler C · Wichita Falls, TXN7721GWurtsboro Airpark LLC · Wurtsboro, NYN7721HRegistration Pending · Juneau, AKRegistration pendingN7721JJgm Aviation LLC · Spring, TXN7721NRome Nicholas S · Olathe, KSN7721WKosobud Timothy J · Adams, WIN77222Davis Sam Alan · Wendell, NCN7722GKnaack Roland · Cumming, GAN7722HRickman Allen K · Absarokee, MTN7723DLutz Roald F · Sandia Park, NMN7723NFord Charles D · Clifton, TNFirst renewal noticeN7723VKearney Stephen L · Oakland, CAN7724GWind Walker LLC · Tucson, AZN7724PWay Steven J · Colleyville, TXN7725KKansas State University Salina · Salina, KSN7725NHangar Twenty Two Aviation LLC · Athens, TXN7726DClaypool Bruce W · Bethel, AKN7726KMcdonald Walter S · Park City, UTFirst renewal noticeN7726POcallaghan David · Bonney Lake, WAN7726TWildwood Aerospace LLC · Cabot, ARN7726WJrw Flight LLC · Huntsville, MON7727GSkyhawk Air LLC · Brunswick, GAN7727WAukee Isaac J · Ironwood, MIN7728GTakeflight LLC · Spanish Fork, UTN7728KPolkowske Leroy A · La Jara, CON7728NP-Factor Aviation LLC · Hoover, ALN7728WSchrage Kevin J · Trevor, WIN7729CPeterman Keith · Taylorsville, KYN7729GValiair Lc Trustee · Casper, WYN7729HHayes Daniel S · Waupaca, WIN7729YFogle Neil · Conroe, TXN772BDSmith Joy I · Mccall, IDN772CAChristiansen Aviation LLC · Wilmington, DE
Back to AD 90-04-06 R1