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.
N443MGGeorgia Aviation Authority · Eastman, GAFirst renewal noticeN443MKNorth Star Aviation · Mankato, MNN443MWKarren Kade R · Mountain Home, IDN443PABird Acquisition LLC · Phoenix, AZN443PKRegistration Pending · Kalispell, MTRegistration pendingN443RLGuinn Timothy J · Jennings, LAN443RVHansen Eric B · Freeland, WAN443TTGudsteinn Thor Thordarson · La Porte, INN44400Vonditsianou Michalis · Milpitas, CAN44407Kroneck Timothy S · Plymouth, WIN4440HSommer John J · Seattle, WAFirst renewal noticeN4440LHutchison John · Big Lake, AKN4440PApac LLC · Berlin, NJN4440ZThompson Logan T · Alliance, NEN44411Ruiz Raul · Sugar Land, TXN44412J Mar Corp · Pittsburgh, PAN44413Premier Capital Enterprises LLC · Hurricane, UTN44416Registration Pending · Punta Gorda, FLRegistration pendingN4441HGoldfarb Martin R · Scottsdale, AZN4441JPinkston Lance C · Batesville, ARN4441MJohnson Arnold R · Mina, SDN4441PMartinson Dominick T · Valdez, AKN4441RAtwood Flying Club · Atwood, KSN4441ZThoft Matthew M · Wasilla, AKN44420England James M · West Paducah, KYN44421Rojas Alissa · Warwick, RIN44426Skyborne Airline Academy Inc · Vero Beach, FLN44429Bettencourt David A · Dayville, CTN4442AVella La Cava Air LLC · Albuquerque, NMN4442HWeber Robert J · Manhattan, KSN4442XHayes Kevin R · Richmond Hill, GAN4442ZKrutzfeldt John · Powderville, MTFirst renewal noticeN44430Red Eye Aviation LLC · Minocqua, WIN4443AVollman Merlin · Pearland, TXN4443QSkyborne Airline Academy Inc · Vero Beach, FLN4443TKristofzski John · West Richland, WAN4443XFox Two LLC · Camino, CAN4443ZMeekin Michael J · Palmer, AKN44442Cummins Stephen Michael · Fenton, MON44443Jax Navy Flying Club · Jacksonville, FLN4444AWesolowski Chris E · Anchorage, AKN4444EIllsley Roger J · Santa Rosa, CAN4444JMoore James Jeffrey · Midlothian, TXN44450Brown Roy A · Morongo Valley, CAN44452Cdr Aviation LLC · Kalispell, MTN44458Forsman Airways LLC · Glenwood, MNN4445JSkyborne Airline Academy Inc · Vero Beach, FLN4445KSkyborne Airline Academy Inc · Vero Beach, FLN4445MClark Stanley E Trustee · Redmond, ORN4445PSkyborne Airline Academy Inc · Vero Beach, FL
Back to AD 90-04-06 R1