AD 90-04-06 R1
Registered aircraft · 68,377
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-04-06-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-04-06-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-04-06-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-04-06-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.
N5253UKronauge Frank A · Dayton, OHN5253WSlipstream LLC · Cherokee, IAN52543Berry Curtis L · Williamsport, MDN52545Plane Fun Inc Tr Trustee · Snellville, GAN52546Eaton Rosemary D · Vernon, NYN5254DR&R Aero Services LLC · Eden Prairie, MNN5254JWorcester Naa Flying Club · Worcester, MAN5254KStone To Glass LLC · Lake Worth, FLN5254XDahl Kevin A · Fargo, NDN5254ZPongracz Lajos Janos · San Antonio, TXN52558Rocky Mountain Equipment Rentals LLC · Mesa, AZN5255HNorth Anthony · Rockwood, MEN5255MFlesher William Robert Jr · Gainesville, GAN5255SAkc III Aviation LLC · Port Saint Joe, FLN5255TGood Joseph A · Weymouth, MAN5255UFlight Gear Aviation LLC · Pickerington, OHN5255WHoppes Curt · Saint Jacob, ILN5255ZGeorge James C · Lenoir, NCN5256DTall Timber Flying Service LLC · Kalispell, MTN5256HHenley Robert J · Jeffersonville, INN5256LIngram Aviation LLC · Johns Island, SCN5256ZKirkpatrick Theodore J · Gwinn, MIN52578Wall Leslie A Trustee · Stevensville, MDN52579Urquhart David L · Winchendon, MAN5257HWellman David H · Eugene, ORN5257RTheodossiou Chris · Mandeville, LAN52582Wheeler Kevin K · Thornville, OHN52585Colley Reid W · Pauls Valley, OKN52588Pursuit International Inc · Stuart, FLN52589Audritsh John E DBA · Indianapolis, INN5258BMathis Ryan B · Madison, ALN5258HFrenzel Carl O · Midlothian, TXN5258RZwiesler Thomas F · Ellington, CTN5258ZSt Pete Aviation Services LLC · Saint Petersburg, FLN52593Mccarthy Justin P · Western Springs, ILN5259HTrifunovic Stefan · Grosse Pointe Park, MIN5259LPennsylvania Flying Assoc Inc · Saegertown, PAN5259RCarnathan Robert J · Newark, CAN525CSPrivitt Bret J · Forest Hill, TXN525FLSiebert Derrick R · Wausau, WIN525GHLauff Samuel Jr · Ocala, FLN525HFVintage Wings Aircraft LLC · Center Point, INN525HPPudenz Ricky A · Glidden, IAN525PULindsay Aviation Inc · West Seneca, NYN525RTLester Wm Curtiss · Martinsville, VAN525SAbles Kenneth M · Taylor, AZN525SBAdams Sidney R · Belle Haven, VAN525STSkywest Leasing Inc · St George, UTN525TSBurch Gary L · Ocala, FLN525UKDabney Rick L · Santa Rosa, CA
Back to AD 90-04-06 R1