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.
N5201VMg Aircraft Inc · Fort Lauderdale, FLN5201WStevens Wayne E II · Denver, CON5201XSims Raymond H · Navarre, FLN5201YShared Momentum LLC · Wilmington, DEN5201ZNunn Adam L · Abilene, TXN5202Fischer Robert L · Oakland, ORN52028Keyes Richard A · Port Saint Lucie, FLN5202EMcdowell William R · Corpus Christi, TXN5202JLizco Aviation LLC · Jackson, MON5202RHahn Douglas Keith · Waldport, ORN5202TBartella Eric A · Canastota, NYN5202WKrishna Ashwin G · Staten Island, NYN5203DAcumen Aerotech LLC · Rogers, TXN5203LMelnik George L · Wheeling, WVN5203RGehman David W · Atmore, ALN5203ZWeigel Gary R · Valley City, OHN52044Peck John E · Everett, WAN52046C10 Fire Aircraft Holding LLC · Sunriver, ORN52048Time Flyers LLC · East Troy, WIN5204LChappell Earl W · New Cumberland, WVN5204MZenteno Nelson Jr · Winter Haven, FLN5204VNimier Alexander M · Chatsworth, CAN5204ZGodbey Patrick E T · St Simons Island, GAN52050Brown Thomas A · Lake Stevens, WAN5205BHarms Frederick L · Hesperia, CAN5205DAlleghany Flying Club Inc · Hyndman, PAN5205LPons Miguel E · Aptos, CAN5205RValley Pilots Flying Club Inc · Martinez, CAN5205THangar 9 Inc · Aberdeen, SDN5205WAircraft 1821 LLC · North Charleston, SCN52061Ortego Kenton M · Lake Charles, LAN52062Rpm Inc Flying Club · South Holland, ILN5206BStaffeldt David S · Hardwood, MIN5206HMccallum Michael C · Delta, CON5206LNora Jet LLC · Granbury, TXN5206MAeropaws Aviation LLC · Front Royal, VAN5206PHyde Roy Wiliam · Sacramento, CAN5206RNewlon Rudolf W · Encinitas, CAFirst renewal noticeN5206ZFord Dustin D · Clear Brook, VAN52074Harris Nancy B · Christiansburg, VAN52076Macair Aviation LLC · Xenia, OHN5207LDon'T Panic! LLC · Vancouver, WAN5207QDairy Air Inc · Wyoming, PAN52082Birdsall Mark A · Berthold, NDN52087Bodkin Donna E · Patchogue Village, NYN52089Wilcox Michael B · Bradenton, FLN5208DVarsity Flight Ops LLC · Las Vegas, NVN5208HSweet Richard S · Prior Lake, MNN5208JFly Dreams Aircraft Group Inc · Fort Lauderdale, FLN5208PDale Snooks One On One Inc · Mancelona, MI
Back to AD 90-04-06 R1