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.
N303HCN303hc LLC · Amarillo, TXN303PCJc Pace Holding Co · Fort Worth, TXN304JSRegistration Pending · Pharr, TXRegistration pendingN304PCFlorida Avm LLC · Venice, FLN304SHJaimlubec LLC · Austin, TXN3052KUas Transervices Inc · Boca Raton, FLN305SAIndigo Blue Aviation LLC · Spartanburg, SCN305ZPLewis Aviation LLC · Baton Rouge, LAN306PAAerotrust Services Corp Trustee · Wilmington, DEN307DMBank Of Utah Trustee · Salt Lake City, UTN308DTTippmann Industrial Products Inc · Fort Wayne, INN308GLN308gl LLC · Fort Worth, TXN308MRStonegate Holdings LLC · San Antonio, TXN308TWCentral Connecticut Aircraft LLC · Plainville, CTN30AFEchelon Diagnostics Inc · Reno, NVN30AVExtraordinaire Aviation LLC · Fairfield, OHN30CVTweety Bird LLC · Henderson, NVN30FEBpnr LLC · Lubbock, TXN30GRGreat Ride LLC · Meridian, MSN30HVCustom Fabricating & Repair Inc · Marshfield, WIN30RLRomeo Tango Aviation LLC · Rockford, ALN30SETradewinds 12/21 Inc · Denison, TXN310TXRiddles Group Inc · Rapid City, SDN3116BIntegrity Air LLC · Jefferson, TXN3116TOrion Aerial LLC · Reno, NVN311CSCtw Holdings LLC · Friendswood, TXN312DEBest Aircraft Deals LLC · Salt Lake City, UTN312GSGolden Shamrock Associates LLC · North Platte, NEN312NCDiva Air LLC · Bloomfield Hills, MIN313CTAlmar Aviation LLC · Greenville, KYN313SAMccarty David M · Baker City, ORN315CSN Fl Servicing LLC · Santa Rosa Beach, FLN316CLCalco 316 LLC · Frisco, TXN316GCMarc Aircraft Holding LLC · Soldotna, AKN316RSTriple Rainbow LLC · Princeton, INN316WHWhiskey Hotel Aviation Inc · Middletown, DEN3170BSpring Mountain Enterprises Inc · Corvallis, ORN318CTJr & M Air LLC · San Antonio, TXN318GLFamily Air LLC · Louisville, KYN318RWMueller Aero Inc · Prairie Du Sac, WIN31CVN31cv LLC · Thompsons, TXN31WCPro Serve Aviation LLC · Englewood, CON320CBHoneymoon Properties IV LLC · Winfield, ALN321VAValiair Limited Co Trustee · Casper, WYN322GTInde Aero LLC · Chandler, AZN322MAN322ma LLC · Reno, NVN322VAEagle Cap Leasing Inc · Enterprise, ORN323EBOzark Air LLC · Prairie Grove, ARN323JRS550 LLC · Breaux Bridge, LAN323NENcw Aircraft LLC · Wenatchee, WA
Back to AD 90-06-13