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.
N7677KDailing Todd A · Fort Atkinson, WIN7677PHenderson William C · Grafton, WVN7677RAlpha Bravo Charlie 1 Corp · Houston, TXN7677VDoxtator Christopher P · Covington, INN7677WNikolic Peter Jr · Momence, ILN76786Engeman Nathon G · Bend, ORN7678DEldridge William D · Anchorage, AKN7678GTanner Michael J · Hooksett, NHN7678HGoth Tedd Lloyd · Hereford, AZN7678PMunday Jeff R · Waverly, GAN7678WDsr-Cherokee 180 LLC · Dallas, TXN7679FScott Field Flying Club LLC · Elgin, IAN7679GShipp-Hove Kylan · Mesa, AZN7679HSummerskyz Inc · Urbana, ILN7679RSmith Melissa R · Atlanta, ILN767ABKoelsch Anthony W · Anchorage, AKN767ACWooldridge Kent L · Albany, ORN767AWTooth & Go Flyers LLC · Farmington Hills, MIN767BRRv8r Aviation LLC · Wilmington, DEN767CDTyler Flyers Inc · Tyler, TXN767DCMariah Aviation Corp · Miami, FLN767DNRegistration Pending · Manchester, MIRegistration pendingN767DPBeardsley William A · Tracy, CAN767ERJet Stream Jockey LLC · Venice, CAN767EWShaffer Jon Michael · Colorado City, CON767FTRenner Brian E · North Port, FLN767GCKiernan Eric J · Bozeman, MTN767GLShemo George T · Newnan, GAN767GPGoodwinds Aero LLC · Roseburg, ORN767GSGriffith William A · Gainesville, GAN767HWMercer Kenneth D · What Cheer, IAN767JJLiberty Aero Executives LLC · Carmel, INN767JMMc Kiernan John E · Navarre, FLN767JSStarr Jeffrey J · Naperville, ILN767JWRoads End Aero LLC · Erwinna, PAN767KLLowrance Kathleen C · Port Orange, FLN767KPPhill-Air Inc · Dover, DEN767LAN767la LLC · Philadelphia, PAN767LHJones Aircraft Co LLC · Cross Plains, TNN767LWMiller Wayne L · Santa Monica, CAN767NTognoli Steve F · Union, ORN767NDUniversity Of North Dakota · Grand Forks, NDN767PAviation Investments Inc · Virginia Beach, VAN767PAPurdue Aviation LLC · West Lafayette, INN767PEDaytona Aircraft Leasing LLC · Daytona Beach, FLN767PMMccord Paul F · Indianapolis, INFirst renewal noticeN767RCTalarik Air LLC · Memphis, TNN767SECoyote Aviation LLC · Carefree, AZN767TVMurphy Craig D · Boise, IDN767WMMcmaster Wayne R · Jeffersonville, IN
Back to AD 90-04-06 R1