AD 2007-04-19 R1
Registered aircraft · 108,434
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:2007-04-19-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:2007-04-19-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:2007-04-19-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:2007-04-19-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.
N387JRThree Eight Seven Jr LLC · Sunray, TXN387JVBonura Rocco F Jr · Perkinston, MSN387LCCooper Gerald W · Kennewick, WAN387LRWoodruff Howard G · Goodyear, AZN387MAAzul Services LLC · Bozeman, MTN387RCrossley Eber G · Farmington, NMN387SPMsb Aviation LLC · Rockvale, TNN387TBP5 Aviation LLC · Cumming, GAN387VBEnt Aviation LLC · Smithfield, VAN387WYSvp LLC · Missoula, MTN387XDowns Rodney A · Anchor Point, AKFirst renewal noticeN387ZLily Pad Aero LLC · Minneapolis, MNN38804H And R Aviation LLC · Jonesboro, ARN38809Somerset Air Service Inc · Bedminster, NJN3880CGreer Glenn M · Eugene, ORN3880DWallace David L · Huntersville, NCN3880QJ&J Hangars LLC · Newnan, GAN3880TThoms Gregory S · Adkins, TXN3880WSpecialized Communications · Smithsburg, MDN3880YLake Country Aviation LLC · Milledgeville, GAN38818Rogers Jason · Limerick, PAN3881XVincent Ricky M · Clinton, LAN3881YNorton Tim C · Danville, VAN3882GRanier Flight Service LLC · Friday Harbor, WAN3882QRiddle Kenneth G · Cherryville, NCN3882RPeterson Dennis W · Grenora, NDN3882ZHarwood Thomas K · Fairbanks, AKN38836Angelle Martin · Slidell, LAN3883PMontana Air Service Corp · Big Timber, MTN3883QAir Williams LLC · Arlington, TXN3883TPaul Novak Mdpc · Des Moines, IAN3883XCallicoat Roger · Chesapeake, OHN3883ZBrossia Jerry L · Eagle River, AKN38840Abdelmegid Shokria M · Desert Hot Springs, CAN38841Savate Lloyd S · Berkeley, CAN38842Scud Rat LLC · Valparaiso, INN3884DBryant Melvin Barry · Cascade, IDN3884PKeffalos Chris S · Anchorage, AKN3884QWrangell Mountain Air Inc · Palmer, AKN3884ZChestler Craig M · Soldotna, AKN38852Hesston College · Hesston, KSN38859Castlerock Realty Investments LLC · Visalia, CAN3885GRichland Aviation Inc · Sidney, MTN3885MGough William N · Vancouver, WAN3885QGades Allen L Trustee · Montevideo, MNN3885TN3885t LLC · Howell, MIN3885XAgledor Bob Sr · Edgewater, FLN3885ZGlidewell Arthur C · Mc Neal, AZN38861Mahaffey Jeffrey · Bristol, TNN38868Spain Brandon R · Pace, FL
Back to AD 2007-04-19 R1