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.
N324LMCirrus Wings LLC · Jefferson City, MON325JFN325jf Operating LLC · Dallas, TXN325PKBlackdog Jet LLC · North Las Vegas, NVN325RDLow Tide LLC · Riverside, IAN325SJMamia Motorsport · Katy, TXN325WPBlue Ridge King Inc · Martinsville, VAN3262MU S Department Of Homeland Security · Washington, DCN326AJVanderloop Equipment Inc · Brillion, WIN326RTPerfect Agreements Leasing Inc · Trabuco Canyon, CAN327HWN327hw LLC · Amarillo, TXN327MEReach Co LLC · Hughson, CAN327RBAerial Applicators Of Missouri LLC · Pollard, ARN328CRDmg Aero LLC · Hickory, NCN329PVN329pvrtbkcitation5 LLC · Las Vegas, NVN32SMValley Air Service Inc · Wayne, ILN32SVDoorless Leasing LLC · Lewes, DEN32TPIal Corp · Lewes, DEN330AFUas Transervices Inc · Boca Raton, FLN330DKBlue Canyon Ventures LLC · Elgin, SCN330ENUniversal Hydrogen Co · Hawthorne, CAN330VPJ & N Leasing LLC · Spokane, WAN331AAAsher Aviation Group LLC · Durango, CON331BRBuffalo Bayou Air LLC · Houston, TXN331MW331 Mike Whiskey LLC · Scottsbluff, NEN331PRAmerican Mine Research Inc · Rocky Gap, VAN332CAPhysicians Air Transport LLC · Hot Springs, ARN332MTOregon Trail Eye Center Pc · Scottsbluff, NEN333AHAerotrust Services Corp Trustee · Wilmington, DEN335CSHessjet LLC · Mc Donald, TNN335RJWings II LLC · Birmingham, ALN335TAN335ta LLC · Anchorage, AKN33610Gibson Aviation LLC · Palacios, TXN338RSr Air LLC · Schamburg, ILN33EKEastview Properties LLC · Memphis, TNN33KCCarvair LLC · Salem, ORN33PXAirtime LLC · Mont Belvieu, TXN342AJFlightpath Aviation Services Inc · Brooksville, FLN3489Vspa Citation Holdings LLC · Davie, FLN348CMCavu Transportation LLC · Hayden, IDN3509RAnalog Yankee LLC · Boulder, CON350WCN350wc LLC · Clovis, NMN351CJSkyview LLC · Wilmington, DEN352CCConcept Aviation Of North Florida Inc · Gainesville, FLN353HAMpr Aviation LLC · Wilmington, DEN356ERStraight Flight Nevada Commercial Leasing LLC · Sparks, NVN356SAJmp Aircraft Services LLC Trustee · Wasilla, AKN357BERegistered aircraftN3616Carter Machinery Co Inc · Salem, VAN361KABehrens Investments Of Wisconsin LLC · Waukesha, WIN362TWInjury Care Center LLC · Alpharetta, GA
Back to AD 90-06-13