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.
N363CAAlpha Mike Aviation LLC · Murfreesboro, TNN365CSN365cs LLC · Mcallen, TXN365EARubi Aviation Inc · Dallas, TXN365WACrossland Air LLC · Bentonville, ARN367JCWalter Oil & Gas Corp · Houston, TXN368BEDos Amigos Transport LLC · Austin, TXN368HSTaylor Aviation LLC · Virginia Beach, VAN369LSLonestar Aviators LLC · Houston, TXN36CPTitan Aviation LLC · Wilmington, DEN36PTMadix Inc · Terrell, TXN370TPPhmi Aviation LLC · Lewes, DEN37201U S Department Of Homeland Security · Washington, DCN372JBUltra Property Acquisitions LLC · Edinburg, TXN375DSTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN376RARocket Air LLC · Broomfield, CON378SFTrigg David D · Houston, TXN379ECRebus II LLC · Owasso, OKN37ETJh Aviation LLC · Rainier, ORN37MHBeech Construction Inc · Pittsburgh, PAN380CFBarkley Air LLC · Scottsboro, ALN381CWN650rj LLC · Marshall, MNN381RUc Aviation Holdings LLC · Union City, TNN383JPAtlanta Air Charter Inc · Kennesaw, GAN384EMIsi Aviation Support Services LLC · Broken Arrow, OKN386CDItasca Aviation LLC · Missoula, MTN387AStatewide Transportation LLC · Oklahoma City, OKN387GDDodson International Parts Inc · Rantoul, KSN387MMMesquite Aviation LLC · Lewes, DEN38MRCam Jet Aviation LLC · Lamesa, TXN38NAK Air LLC · Orangeburg, SCN38TTJettech Holdings LLC · Broomfield, CON391DTN2028w LLC · Ripon, CAN391HCFly-Area LLC · Charleston, SCN391JMMeisner Aircraft Inc · Janesville, WIN392CAInternational Air Services Inc Trustee · Carson City, NVN393EHarvest International Ministries Inc · Texarkana, ARN393JCFlycarolina Jet Partners LLC · Charlotte, NCN393JWGeneration Jets LLC · Denison, TXN3AHEat Veggies 3 LLC · Savannah, GAN3HBSunset Aviation LLC · Port Angeles, WAN3RBSx Transport LLC · Portland, ORN400DAFive Saguaro Leasing LLC · Albuquerque, NMN400ECDelta Mike Holdings LLC · Pensacola, FLN400KSNbs Air LLC · Creve Coeur, MON400SLTurbo Air Charter LLC · Boise, IDN401HTTailwinds LLC · Houston, TXN401NSNs 300 LLC · Atlanta, GAN402RX56 Express LLC · Willmar, MNN4031B40thirty1 Aviation LLC · Panama City Beach, FLN403ETFlymehlingav LLC · Tyler, TX
Back to AD 90-06-13