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.
N7167RPriewe Jeff C · Como, MSN7167WBuckley Barney P · Colfax, WAN7167YThomas Thomas J · Lewisburg, WVN7168GDurbin John W · Lovington, ILN7168HHindes Philip W DBA · Charlotte, TXN7168KDotzenroth David A · Watertown, MNN7168LAltaii Ali A · Gibraltar, MIN7168MWindh Steven R · Reedley, CAN7168PSchober Brian S · Scottsdale, AZN7168RParham Maxwell V · Madison, MSN7168UMorris Charles P · Uvalde, TXN7168WDestination Flyer LLC · Memphis, TNN7169BNorthern Peaks Flight Training LLC · Wasilla, AKN7169FPillar Aviation Services LLC · Auburn, NHN7169JWatson Terry D · Norman, OKN7169RBrock Charles Calvin Jr · Pendleton, SCN7169VPrh Farms Inc · Gettysburg, SDN716ABRice Flying LLC · Corning, ARN716ACAlexandrov Boyan · Reno, NVN716CNNordquist Conrad · Jurupa Valley, CAN716DCHesano Joseph M · Rockford, ILN716ERFly With Bruno LLC · Mountainside, NJN716GAtp Aircraft 9 LLC · Wilmington, DEN716JJKeenum Jc · Loveland, CON716KUrbanczyk Kirk M · Draper, UTN716LWWigley Eddie G · Howell, MIN716NDUniversity Of North Dakota · Grand Forks, NDN716RHPowers Alan J · Fayetteville, GAN716RLPerguson Robert Cole · Converse, TXFirst renewal noticeN716RSSprouse Ronald E · Port Orchard, WAN716SPExec 1 Aviation II LLC · Ankeny, IAN7170GSs Skyways LLC · Becker, MNN7170RBrown Joshua A · Fayetteville, GAN7170UWorley Ronald W · West Jefferson, NCN7170VKrack John L Trustee · Fridley, MNN7170WMontana Thomas · Port St Lucie, FLN7171FFriedrich Richard L · Georgetown, TXFirst renewal noticeN7171QMcnamara Bradley W · Seattle, WAN7171RYoungblood Steven H · Gilmer, TXN7171YHeinrich Steven W · Conroe, TXN71728Guskea Andrew E · Jericho, VTN7172KMeader Derek S · Marfa, TXN7172QRounds Agronomy LLC · Pierre, SDN7172UMark21-Charlie LLC · Brownsburg, INN7172VGanji Borna · West Windsor, NJN7172WSkrypai Vladislav · Poplar Grove, ILN7173BEavenson Daniel Scott · Ripon, CAN7173GSale Reported · Haiku, HISale reportedN7173QWesterly Av Group LLC · Westerly, RIN7173RRushton George E · Clinton, MI
Back to AD 90-04-06 R1