AD 90-15-15 R1
Registered aircraft · 826
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-15-15-R1')
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-15-15-R1')
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-15-15-R1') 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-15-15-R1') 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.
N5060UPeoples Douglas A · Horseshoe Bay, TXN5061KSchweiss Charles · Fairfax, MNN5061NGroth Matthew C · Arlington, WAN5062CSchiegner Kyle Glen · La Mesa, CAN5062DRoberge Guy C · Westborough, MAN5062KBennett George III · Lambertville, NJN5062PPiercy Ronald S · Moses Lake, WAN5062YDerossett Trevor · Manville, ILN50636Placer Aviation LLC · Loomis, CAN5063LVirga Aviation LLC · Virginia Beach, VAN5063YPlane Fun Inc Tr Trustee · Snellville, GAN5064URowe Timothy R · Texarkana, ARN5067KN5067k LLC · Lenexa, KSN5068GScaled Composites LLC · Mojave, CAN5069TNiesciur Stephen V · Lancaster, NYN5069UGoff Bayou LLC · Shelby, MSN5070GSky Fusion II LLC · Atlanta, GAN5070NWilkinson Dane W · Morgan, UTN5070UO'Donnell Paul E · Schuylerville, NYN50CLLopez Johnny · Henderson, NVN50LRHester Truck Sales Inc · Bladenboro, NCN50XDBest-Devereux Igor · Salt Lake City, UTN50XTN50xt LLC · San Lorenzo, CAN50YYJambon Pierre · Port Orange, FLN510LSRegistration Pending · Nashville, TNRegistration pendingN515PGHunter Gregory · La Jolla, CAN515SED & H Equities LLC · Helena, MTN519MKMcleod Martin · Carthage, NCN51CBPukach Greg V · Topeka, KSN5220XCartwheel Aviation LLC · Boise, IDN52245Poursartip Nader · Hayward, CAN52GMSchneider Jeffrey A · Pensacola, FLN52LWN8138l LLC · Metairie, LAN536CMCherry Hill Aviation Inc · Freetown, INN53737Diloreto Gregory T · Jupiter, FLN53747Tenkey Investments LLC · Tulsa, OKN537ACMacmillan John Jr · Chevy Chase, MDN53818Prestige Worldwide Aviation LLC · Downers Grove, ILN53834Morrison Dale C · Eloy, AZN53838Euroaviation Inc Trustee · KematenN53870Vier Bradford Edward · Austin, TXN53876Lynch Wayne H · West Branch, IAN53895Stebbins Scott · Elk, WAN538EELight Speed Air LLC · Los Angeles, CAN53900Nielsen Jeffrey A · Frankfort, MIN53902Jackson Todd · East Wenatchee, WAN53909Rawlings Cecile Cole · Palatine, ILN53975Cox Kelsi J · Williamsburg, IAN53982Pearson Scott A · Tipton, IAN53CCPcb Air LLC · Wilmington, DE
Back to AD 90-15-15 R1