AD 90-06-13
Registered aircraft · 1,827
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-06-13')
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-06-13')
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-06-13') 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-06-13') 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.
N523YATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN524MRMt King Air · Stevensville, MTN524XAOn Three Angels Wings LLC · Melbourne, FLN525JANewsome Jeff S · Blackwell, OKN525PEFliteaccess LLC · Louisville, KYN525RDGjjl Equipment LLC · Houston, TXN5263Big River Aviation LLC · Bonne Terre, MON527RYVesta Faye Leasing LLC · Abbott, TXN528BCBeech Creek Coal Corp · Roanoke, VAN528DXXitp LLC · Newark, DEN528KWDavenport Financial Group Inc · Oklahoma City, OKN529TGJet Connection LLC · Hamilton, OHN52LTBc Aero Holdings LLC · Dover, DEN52WFBas Part Sales LLC · Greeley, CON530CLGilgal Stones Consulting LLC · Flint, TXN531AWCsi 135 Division LLC · Albuquerque, NMN531THCrimson Skies LLC · Pelham, ALN532AWCsi Aviation Inc · Killeen, TXN534AWCsi Aviation Inc · Killeen, TXN534HHec Aviation LLC · Shelbyville, TNN535BPBum Aviation LLC · Green Bay, WIN535MPLouisville Aviation LLC · Louisville, KYN535PNDavis Aviation Inc DBA · Brandon, MSN539ARBank Of Utah Trustee · Salt Lake City, UTN539JMN539jm LLC · Clovis, NMN53BAIvester Drywall & Painting Inc · Salisbury, NCN53DDResort Air LLC · Honolulu, HIN53FPDodson International Parts Inc · Rantoul, KSN53HAInky Aviation LLC · Sellersburg, INFirst renewal noticeN53KADesert Mountain Air LLC · Kalispell, MTN53LPN53lp LLC · Amarillo, TXN53PE3cap Aviation LLC · Scottsdale, AZN53SMClayton Leasing Inc · Aberdeen, MSN53STBlue Link LLC · Bay City, WIN541SRider Terry · Corinth, MSN541SCKing Air N541sc LLC · Fresno, CAN544CGCoulson Aviation (USA) Inc · Portland, ORN546CGCoulson Aviation USA Inc · Portland, ORN547CGCoulson Aviation (USA) Inc · Portland, ORN548CGCoulson Aviation (USA) Inc · Portland, ORN549CGCoulson Aviation (USA) Inc · Portland, ORN54CHLawsuit Air LLC · Onalaska, TXN54DDChrysler Aviation Inc · Van Nuys, CAN54HTBravo V Aviation LLC · Harrisburg, PAN54TKDlp Real Estate Capital Inc · Saint Augustine, FLN54TPTsc N94pl LLC · Wichita Falls, TXN550ABAbt Aviation LLC · Bay City, MIN550AJCola Express LLC · Ripley, WVN550AS550 LLC · Kalispell, MTN550BCCb Air LLC · Fayetteville, AR
Back to AD 90-06-13