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.
N725CCFlight Oklahoma City Air LLC · Oklahoma City, OKN725DSData Sales Co Inc · Burnsville, MNN725JADans Flying Circus LLC · Danbury, CTN725RABar Environmental Supply Inc · Brentwood, TNN725RHEstancia Aviation III LLC · Reno, NVN726HASurdex Corp · Chesterfield, MON727EFCamaero Inc · Wilmington, DEN727TXCitation N79kf LLC · Naples, FLN728CRCdsm 601 LLC · Opa Locka, FLN729AKDavis Aviation Inc DBA · Brandon, MSN72HTSan LLC · Knoxville, TNN73Federal Aviation Administration · Oklahoma City, OKN731TRSapphire Living Inc · West Linn, ORN734DBN779at LLC · Punta Gorda, FLN737MMMadrock LLC · Dallas, TXN740JMTailwinds LLC · Houston, TXN740RBSummit Capital Partners Aviation Services LLC · Houston, TXN746KFTriple Fes LLC · San Antonio, TXN749TTHarpe Air LLC · Horseshoe Bay, TXN74GRRobinson George A IV · Houston, TXN74GZ921be LLC · Clarksdale, MSN75Federal Aviation Administration · Oklahoma City, OKN750CKMn Aircraft LLC · San Juan, PRN750FLTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN750JMTailwinds II LLC · Houston, TXN750KAN750ka LLC · Wilmington, DEN750MLLincoln Industries Inc · Lincoln, NEN750TTDodson International Parts Inc · Rantoul, KSN753GJWarhawk Aviation LLC · Baton Rouge, LAN753MBSteel Diamond LLC · Sheridan, WYN757GWGreenway Air LLC · Wilmington, DEN757TRRegistered aircraftN7586ZGould Aviation LLC · Aberdeen, SDN758SLGoldstein Investment Group LLC · Omaha, NEN75DHBrent Staggs Medical Consulting LLC · Little Rock, ARN75TMMilazzo Holdings LLC · Wales, WIN75WPSalt River Project Agric Improvement & Power Dist · Phoenix, AZN76Federal Aviation Administration · Oklahoma City, OKN760ASNorsan Investors LLC · Concord, CAN760MSurdex Corp · Chesterfield, MON764JSAhw Aviation Inc · Anchorage, AKN765RDCitation 550-399 LLC · Lewes, DEN765WAValiair Lc Trustee · Casper, WYN767KCBig Orange Sky LLC · Green Bay, WIN768JSSfh Inc DBA · Fargo, NDN769BBJ2s LLC · Benton, ARN76ASGs Ici Holdings LLC · Beaumont, TXN76RBLe Norman Avion LLC · Oklahoma City, OKN76TFFca LLC · Leawood, KSN77Federal Aviation Administration · Oklahoma City, OK
Back to AD 90-06-13