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.
N584FLQuantum Aviation Services LLC · Lakewood Ranch, FLN584KButterfield Rory A · Milan, NMN584LLawver William A · Panama City, FLN584LKTipton William M · Burlington, NCN584LMTiede Russell James · Miami, AZN584RVFelix Leonard D Jr · Salome, AZN584SShobe Andrew S A · Clarksville, MDN584SCSpartan Education LLC · Tulsa, OKN584SFDsr Cherokee 180 LLC · Dallas, TXN584SPTexas State Technical College At Waco · Waco, TXN584UConverse Donald A · Los Alamitos, CAN584YKBachman David A · Griggsville, ILN5850LXeus Inc · Nottingham, PAN5850QMcmoran Donald W · Mount Vernon, WAN5850UMarfair LLC · Freeport, TXN5850WCaside Aviation LLC · Brooklyn, NYN5850ZMiller Helen J · Springfield, OHN5851DRubbert Lorin E · Reynolds, NDN5851LOretsky Philip H · South Haven, MIN5851UFoothill Aircraft Sales & Service Inc · Upland, CAN5851VMcconnell Thomas E · Grass Valley, CAN5851WCameron Hugh R · Gainesboro, TNN5851ZBurklund Joel H · Minneapolis, MNN5852HKelley Don Lee · Loon Lake, WAN5852LOhser David G · Hudson, FLN5852QOldham Jared K · Richfield, WIN5852WFerguson Carl R · Waupaca, WIN5852ZTuttle James R · Cherryvale, KSN5853DHapka Leon J · Halma, MNN5853LKennedy Samuel E · Watsonville, CAN5853PLewellen Walter G · Moreno Valley, CAN5853UPost Jay M · Greenfield, OHN5854DPro West Air LLC · West Point, UTN5854LVolpe Brandon M · Baton Rouge, LAN5854UMagic Valley Aero Club Inc · Twin Falls, IDN5854WAtluas LLC · Dallas, TXN5855DMiller Justin · Boaz, ALN5855HNortheast Cub LLC · Hudson, NYN5855LSchauf Cindy R · Colwich, KSN5855WZachry David · West Point, GAN5856DStephen George · Land O Lakes, WIN5856HWaco West Inc · Dover, DEFirst renewal noticeN5856LOrland Flying Service Inc · Bunnell, FLN5856QDison Timothy A · Nolensville, TNN5856WSergeant Mary E · Harvard, ILN5856ZHankins Jon A · Fort Mohave, AZN58571Stanger Joseph E · Willow, AKN5857LHill James III · Gainesville, FLN5857VHague Parkerson B · Virginia Beach, VAN5858HKoch Michael R · Nemo, SD
Back to AD 90-04-06 R1